Baselining SQL Server (Part 2)

(Part 1 can be found here.) Last time, I talked about using typeperf to collect Perfmon performance data and store it in SQL Server. This time around, I’ll talk about how to pull that data out and make some pretty reports with it. First off, we’ll need some SQL code to pull the data and […]

Baselining SQL Server (Part 1)

If you are reading this, chances are you like SQL Server. You may even love SQL Server. You might be addicted to SQL Server. I’m here to enable your addiction. Now I can’t say mainlining SQL is good for you, but I can say baselining your SQL servers is. There are several good blog posts […]

Indexing The Lottery

In this post, I walk through the steps of basic index analysis and, although we end up with a fairly obvious solution, we discover that optimizing SQL Server performance sometimes doesn’t even involve SQL Server. One of the occupation hazards, if you will, of being a DBA, is that you tend to think about possible […]