Since we are in the middle of May 2011, I thought was was time to update my SQL Server 2008 Diagnostic Information Queries. These are very similar to the April 2011 version except for one new query at the end of the set.
You can click on the link above to download the queries from Dropbox. What I always recommend is that you run each query separately, after you read the instructions and comments on how to interpret the results. The first half of the queries focus on your SQL Server instance, while the second half focuses on a specific SQL Server database on that instance. That means you want to make sure you are in the context of the right database when you run the database specific queries (not master).
This set of queries will work on both SQL Server 2008 and SQL Server 2008 R2. There is a separate set of queries available for SQL Server 2005, and a separate set available for SQL Server Denali.
I also recommend that you download the matching query results spreadsheet, so that you can copy and paste the results for each query into it, for later analysis. This makes the results much easier to interpret, and lets you keep a record of changes over time.
Pingback: What Are You Waiting For? | John Sansom - SQL Server DBA in the UK
Pingback: Something for the Weekend – SQL Server Links 20/05/11 | John Sansom - SQL Server DBA in the UK
I found these queries are helpful.
1. Do you have these for SQL 2005?
2. I got a very slow full backup. Normally it took about 3 hours, but today, it took 12+hours. I have Spotlight installed and can see teh CPU,MEM usage are low. No blocking found in activity monitor.
I suspect that SAN is cuasing the problem. But how can I prove that to my system team? It will be highly ap[preciated if you can pass me some script or method to identify / resolve the issue.
Thanks.
Pingback: What Are You Waiting For?
Thanks for the mention and link, John!