May 05, 2009

SQL Server 2005 and 2008 Diagnostics Queries and Configuration Checklist

SQL Server MVP, Glenn Berry recently put together a set of Diagnostic Queries to provide a high level overview of how your SQL Server 2005/2008 is configured and to monitor its performance.

Here are the links to these amazing set of queries:

SQL Server 2005 Diagnostic Queries

SQL Server 2008 Diagnostic Queries

SQL Server 2005 Installation and Configuration Checklist

I hope others find it useful too!

Glenn works as a Database Architect at NewsGator Technologies in Denver, CO. He is renowned SQL Server MVP, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. Glenn is also an Adjunct Faculty member at University College -University of Denver, where he has been teaching since 2000. Glenn blogs regularly at

About The Author

Suprotim Agarwal, ASP.NET Architecture MVP works as an Architect Consultant and provides consultancy on how to design and develop Web applications.

Suprotim is also the founder and primary contributor to DevCurry, DotNetCurry and SQLServerCurry. He has also written an EBook 51 Recipes using jQuery with ASP.NET Controls.

Follow him on twitter @suprotimagarwal

No comments: