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

daily CPU / IO possibly RAM information per DATABASE Expand / Collapse
Author
Message
Posted Tuesday, July 1, 2008 9:52 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, September 12, 2009 9:12 PM
Points: 65, Visits: 224
Can any one suggest for the below questions

We need to to achieve to have a method to collect
daily CPU / IO possibly RAM information per DATABASE to be collected on instance level.

Is there any query to find out ?

Please help us
Thanks ain advance
Post #526998
Posted Tuesday, July 1, 2008 9:55 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:10 PM
Points: 33,095, Visits: 15,202
There are a number of DMVs that can get you server information. You can start here: http://www.codeproject.com/KB/database/Dynamic_Management_Views.aspx







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #526999
Posted Thursday, July 10, 2008 1:24 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Saturday, September 12, 2009 9:12 PM
Points: 65, Visits: 224
HI,

I am not getting what i am looking for

What i need is if i execute a qurery in one instance it should display the Database Name and the Cpu usage for that DB

Fileds -Database Name ,Cpu Usage

Any special Queries

Regards,
SMM
Post #531405
Posted Thursday, July 10, 2008 3:54 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 22, 2012 6:45 AM
Points: 52, Visits: 230
As per Steve's reference they are helpful to obtain status of SQL instance and if you want to know more about DMVs then refer to SQL 2005 Books ONline, also refer to http://sqlserver-qa.net/blogs/perftune/archive/2007/08/05/1262.aspx for your information.

-Satya SK Jayanty
SQL Server MVP (Follow me @sqlmaster)
Author of SQL Server 2008 R2 Administration CookBook
SQL Server Knowledge Sharing network
Post #531458
Posted Thursday, July 10, 2008 8:25 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Thursday, January 2, 2014 10:30 AM
Points: 646, Visits: 731
one of the raw methods that goes back to SQL 2000 is to use sysprocesses. You have the CPU and Dbid column, that you can track with hostname and loginame columns. Or Use this
select scheduler_id, current_tasks_count, runnable_tasks_count
from sys.dm_os_schedulers where scheduler_id < 255


Maninder
www.dbanation.com
Post #531661
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse