July 1, 2008 at 9:52 pm
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
July 1, 2008 at 9:56 pm
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
July 10, 2008 at 1:24 am
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
July 10, 2008 at 3:54 am
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
July 10, 2008 at 8:25 am
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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply