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 […]
Now that I’m in a position where I am monitoring a large number of SQL Servers, I’m finding a new appreciation for SSMS. I’ve already written about the error-highlighting trick I recently discovered. Today I’d like to talk a bit about the ability of SSMS to issue commands against multiple SQL Servers at once. I […]
After watching Brent Ozar’s webinar on backups and virtual machines, I was inspired to take a deeper look at our company’s overall backup plans. I had already gone through the code that was actually doing the backup, found some crazy stuff, and fixed it, but this time through I wanted to take a closer look […]