article thumbnail

How To Reduce the Costs of Database Management in Financial Services

Percona

During the recession of 2008, they experienced firsthand how fast money and assets can vanish. Tune and optimize to improve performance Even if you consider your database platform modern, simple database tuning and optimization can speed up your processes significantly.

article thumbnail

Finding Distinct Values Quickly

SQL Performance

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. This machine has four i7 CPUs (hyperthreaded to 8) with a base speed of 2.4GHz. Having a wide range of tools available is generally speaking a good thing when tuning queries. Test Environment.

Servers 86
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Common SQL Server Mishaps

SQL Performance

While hardware such as intelligent SANs, Solid State Disk, and other advancements have helped speed things up, wasted space in index can translate to wasted space in the buffer pool as well as wasting more I/O. Fragmentation occurs through regular operations such as inserts, updates and deletes. SQL Server Agent Alerts.

Servers 49
article thumbnail

Measuring The Performance Of Typefaces For Users (Part 1)

Smashing Magazine

Here are some examples: Neue Haas Grotesk (1956), Helvetica (1957), Arial (1982), Bau (2002), Akkurat (2004), Aktiv Grotesk (2010), Acumin (2015), Real (2015); Frutiger (1976), Myriad (1992), Monotype SST (2017), Squad (2018), Silta (2018); Collis (1993), Novel (2008), Elena (2010), Permian (2011), Lava (2013). Stay tuned!

article thumbnail

Solaris to Linux Migration 2017

Brendan Gregg

Nowadays, there are three built-in tracers that you should know about: - **ftrace**: since 2008, this serves many tracing needs, and has been enhanced recently with hist triggers for custom histograms. It's fast, but limited in places, and usually only suited as a single-user tool (there are workarounds).