July 2011 Version of SQL Server 2008 Diagnostic Queries

Glenn Berry, 2011-06-30

Since July is only one day away, its time for the updated version of my SQL Server 2008 Diagnostic Information Queries. There is also an updated version of the results spreadsheet, with an additional tab for the latest new query in the set.

This new query lets you see whether SQL Server has any Memory Grants Pending according to the SQL Server: Memory Manager performance monitor counter. If you see any value above zero for any sustained time at all, that is a very strong indicator of internal memory pressure.

These queries will all work on SQL Server 2008 and SQL Server 2008 R2. Most of the queries will also work on SQL Server 2005, but there is a separate set of queries that I have for SQL Server 2005, which I am not updating very often, since SQL Server 2005 went out of Mainstream Support back in April of 2011.

One surprise I have in store quite soon is that I will have two new versions of this script that are split into instance level queries, and database level queries, with even more detail about each area. I am adding quite a few new queries for each new script, so they should be even more useful (at least I hope so)!





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


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


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


360 reads