Tune Workloads, Not Queries
Ask three DBAs about their preferred performance tuning methodology and you will get back seven distinct answers.
Ask three DBAs about their preferred performance tuning methodology and you will get back seven distinct answers.
There are many methods available for optimizing the performance of SQL Server. One method in particular is examining your plan cache, looking for query plan warnings. Plan warnings include implicit conversions, key or RID lookups, and missing indexes to name a few. Each of these warnings is the optimizer giving you the opportunity to take … Read more
Every DBA wants to become an expert in query performance troubleshooting. Not every DBA is willing to put in the time and effort it takes to become an expert.
Four years ago I wrote about the DBA Plate, which was a reference to the food plate that replaced the food pyramid right about the time the U.S. Congress declared pizza to be a vegetable. I had every intention of keeping the plate updated annually but never got around to doing so because reasons. Well, today is the day. You’re welcome.
Performance tuning is hard. Everyone knows that. Has anyone ever tried to figure out why? Sure, there’s that big old “it depends” that gets tossed about. Look, at the end of the day you only have so many possible resource bottlenecks: disk, memory, CPU, and network. I don’t care if you are running Linux, Unix, … Read more
Last week I posted a puzzle of sorts. I showed you a handful of graphs from PAL and asked if anyone could determine what had happened. Out of all the comments that were left only a handful of people seemed to be on the right track, or showed a methodology in their thinking that should … Read more