Easiest way to determine what sqlservr.exe is doing

networkn
networkn used Ask the Experts™
on
Hi, we have a number of servers that from time sqlservr.exe  will start using a lot of cpu. It would be useful to know what it's doing during that time.

Is there a nice way with sqlexpress to see what's chewing resources?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Not sure if it's included in MS SQL Server Express, but have you tried opening the Activity Monitor? It should provide you with some info on who's doing what and what kind of queries are being run at that time.
Top Expert 2010
Commented:
use Windows performance monitor to monitor certain SQL counters.

check out this article
http://www.sql-server-performance.com/tips/performance_monitor_general_p1.aspx

then you will know the root cause of your problem

Regards

Author

Commented:
Sorry for the delay, I don't have a current case to test this on.
Top Expert 2010

Commented:
didnt get your point..

Author

Commented:
To determine if what you have suggested for tracking the usage is correct for my circumstance I need to wait for the problem to reoccur so I can test.
Top Expert 2010

Commented:
its ok

take your time

Author

Commented:
Problem hasn't reoccurred, can't really test it until I do, would you prefer me to close the question?
Top Expert 2010

Commented:
dear networkn:

its ok with me, if you need more time take it. am really fine with that, dont worry at all

Regards

Author

Commented:
Problem has not reoccurred. I will close this question and re-open when I have an instance to test on.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial