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/
No comments:
Post a Comment