Post reply

Queries for per database performance

  • May 5, 2014 at 4:46 pm

    #307456

    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!

  • May 6, 2014 at 8:18 am

    #1711086

    For a deep answer on those questions, I suggest you to go to the books section[/url] in this site. You'll find great resources available there.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • May 6, 2014 at 1:55 pm

    #1711255

    Google Glenn Berry's diagnostic queries. They have helped me in various situations and give a good insight in the most important aspects of an SQL Server instance. He has sets per version.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply