I’ve written in the past about the need to create a baseline of your SQL Server’s performance and how to do that. The list of Perfmon counters I used was from a list that Brent Ozar recommended in one of this videos. I saw something last week that made me add a couple. Paul Randal […]
Last week, I showed you some nifty graphs that display Perfmon data from SQL Server. At the time, I warned you that performance was pretty slow and that improvements could likely be had by changing the report to use stored procedures instead of the view I used. I left that as an exercise for the […]
(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 […]
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 […]