SQL Server Performance

Queries for per database performance/utilization

Discussion in 'ALL SQL SERVER QUESTIONS' started by ILikeDatabases, May 5, 2014.

  1. ILikeDatabases New Member

    I'm trying to get a handle per-database performance on my servers (SQL 2005 and 2008 R2) to determine candidates for consolidation; i.e., rank databases by biggest resource consumers. What subsystems should I look at: CPU? Disk I/O? Buffer? Do you have -- or Is there a resource that has lists -- queries for each type of utilization? Thanks for your help!
  2. ichambas New Member

    These DMV scripts will get you started.

    Attached Files:

Share This Page