January 29, 2009 at 10:20 am
Hello,
I am looking for a script which can be ran through sql agent to find out the CPU usage on a machine thats running sql server.
Thanks
January 29, 2009 at 9:09 pm
Why not use perfmon or one of the tools already with the OS Server that would be much easier and give you a better running of whats going on. The script will only give you an instant of when its in use and of course that script alone will increase the cpu usage minimal but nevertheless make your observations somewhat inaccurate. I would go with performance monitor and set up a counter for a few days or however long ..then you can go back and take your time reviewing your data and add other counters if you wanted to (memory usuage, memory free, IO reads/writes, etc) and get a full picture of your server.
Hope this helps... and good luck
-Darryl
DHeath
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply