June 26, 2008 at 10:48 pm
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
June 27, 2008 at 12:33 am
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
June 27, 2008 at 6:19 am
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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy