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 http://glennberrysqlperformance.spaces.live.com/blog/

About The Author

Suprotim Agarwal, MCSD, MCAD, MCDBA, MCSE, is the founder of DotNetCurry, DNC Magazine for Developers, SQLServerCurry and DevCurry. He has also authored a couple of books 51 Recipes using jQuery with ASP.NET Controls and a new one recently at The Absolutely Awesome jQuery CookBook.

Suprotim has received the prestigous Microsoft MVP award for nine times in a row now. In a professional capacity, he is the CEO of A2Z Knowledge Visuals Pvt Ltd, a digital group that represents premium web sites and digital publications comprising of Professional web, windows, mobile and cloud developers, technical managers, and architects.

Get in touch with him on Twitter @suprotimagarwal, LinkedIn or befriend him on Facebook

No comments: