Post reply

To collect CPU Stats for each Database in an Instance.

  • July 1, 2008 at 10:11 pm

    #187780

    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

    #836990

    [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

    #836995

    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

    #837065

    Prathyusha (7/1/2008)

    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.

    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