Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Queries for per database performance Expand / Collapse
Author
Message
Posted Monday, May 5, 2014 4:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 11, 2014 5:11 PM
Points: 1, Visits: 117
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!
Post #1567739
Posted Tuesday, May 6, 2014 8:18 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 11:13 AM
Points: 4,066, Visits: 9,235
For a deep answer on those questions, I suggest you to go to the books section in this site. You'll find great resources available there.


Luis C.
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?

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1567977
Posted Tuesday, May 6, 2014 1:55 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 1:36 AM
Points: 41, Visits: 392
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.
Post #1568173
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse