July 1, 2008 at 10:11 pm
Hi
I wanted a procedure which will collect CPU information about each database ie how much cpu is each database using at a given time..
or information reg which System table,view or proc can be queried to get similar information.
Thanks
Prathya
July 1, 2008 at 10:44 pm
[font="Verdana"]Hi,
Since you are working with SQL Server 2005 you can use DMV's to show these informations. DMV's starting with sys.dm_OS* will provide details about operating system
YOu can use the below query to check CPU utiltization of SQL Server thoguth sql
Finding Out SQL Server CPU usage Using T-SQL Code[/url][/font]
Regards..Vidhya Sagar
SQL-Articles
July 1, 2008 at 11:04 pm
Hi
yeah i checked that page out earlier it shows the cpu time from the entire instance i want it for each dtabase...like in the cpu being utilized by that particular databse when i execute the query.
July 2, 2008 at 3:31 am
Prathyusha (7/1/2008)
Hiyeah i checked that page out earlier it shows the cpu time from the entire instance i want it for each dtabase...like in the cpu being utilized by that particular databse when i execute the query.
you can put set statistics IO on at the start of your query in SSMS, that will show IO stats for you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply