June 2011 Version of SQL Server 2008 Diagnostic Queries

Glenn Berry, 2011-06-02

Since it is June, I thought it was time to update my SQL Server 2008 (and 2008 R2) Diagnostic Information Queries. This month has one new query, which rolls up total CPU usage by database for the current SQL Server instance. This can be useful if you are seeing signs of CPU pressure at the instance level, but are not sure which database is causing it. It is adapted from a query originally written by fellow SQL Server MVP Robert Pearl (web| Twitter).

As always, I strongly suggest that you run each query one at a time, after reading the comments and explanations that go with it. I also recommend that you copy and paste the results from the query results grid into the matching results spreadsheet. If you do that, it makes it easier to save the results over time, so you can better identify issues and trends.

Finally, whenever I update the SQL Server 2008 queries, I inevitably get a number of questions about a version for SQL Server 2005. Since SQL Server 2005 fell out of Mainstream support from Microsoft in April of 2011, I am not spending as much time keeping those queries updated. The latest version for SQL Server 2005 is here.

Rate

Share

Share

Rate

Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis

2009-02-23

1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren

2009-02-17

1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren

2009-02-13

360 reads