Glen Berry posted a collection of queries that can be used in diagnosing SQL Server 2005/2008 metrics/counters.

Excerpt:
"… small collection of queries that can be used to gather a wealth of very useful information about a SQL Server 2005/2008 instance, and about any specific database on that instance.  These queries will tell you the exact version and edition of SQL Server, whether it is 32-bit or 64-bit, the OS version, and some information about the CPUs and memory in the server.  They will also reveal how many databases are present, their recovery models and file layouts.  We also find out what the top wait stats are, along with Page Life Expectancy (PLE) …"

You can find the full post and script here:

http://glennberrysqlperformance.spaces.live.com/Blog/cns!45041418ECCAA960!990.entry

VN:F [1.4.0_681]
Rating: 0.0/10 (0 votes cast)
Share :
  • Digg
  • del.icio.us
  • Google
  • description
  • StumbleUpon
  • Technorati
  • TwitThis

Related posts:

  1. SQL Server PowerShell : How to Audit Your SQL Server Instance Properties Using PowerShell and SMO ...
  2. SQL Server 2008 Jumpstart and other resources ...
  3. SQL Server XML Red Gate Ebook, XQuery Labs ...
  4. SQL Server PowerShell : How to Backup SQL Server Databases Using SMO and PowerShell ...
  5. SQL Server PowerShell : Basics – Connecting to SQL Server ...
  6. Resolving “A network-related or instance-specific error occurred while establishing a connection to SQL Server…” ...