CPU data used by the application databases

• sps-554505

  Default port

  Points: 1463

  More actions

  June 26, 2008 at 10:48 pm

  #126246

  Hi,

  I would like to know how to find out the CPU data used by the application databases

  in SQl server 2005,Is there any query to find out exact usage of CPU

  and also the growth of the CPU usage in a regular interwal

  Regards,

  Shine

• sachinsamuel1

  SSC-Addicted

  Points: 422

  More actions

  June 27, 2008 at 12:33 am

  #835173

  There are many methods you can achive this.

  1) Go to run, type "perfmon". Add counter for CPU. This will give a graphical representaion of load on CPU.

  2) If you want to check load of specific query on server, you can use profiler and check the CPU column.

  3) You can also use DBCC SQLperf

  HTH

  sachin

• sps-554505

  Default port

  Points: 1463

  More actions

  June 27, 2008 at 6:19 am

  #835274

  Hi,

  I have around 30 dbs i need to store the details in one table and to monitor?

  its liek collecting information about Cpu usage,

  could you suggest some queries

  smm