December 5, 2003 at 8:45 am
Is is possible to monitor SQL Server Activity by a connection. We have a user that is running a client application that takes quite a while but are trying to determine if it is hanging or if SQL Server is actually processing. I know you can use Profiler to watch the SQL Statements coming in, but is there any other way to see the Activity by a connection. I have also explorered all the options under Management/Current Activity in Enterprise Manager.
Any Ideas?
December 5, 2003 at 10:02 am
'Profiler' seems to be the best way. I really like this tool although it does decrement Server performance. I may be missing something in your question though. It seems that you would want to use Profiler and filter on the login name or the host, then watch what happens. You have to refresh with Enterprise Manager too much to make it effective..so you may want to find the spid of the process when it logs in then query on the sysprocesses table and watch the 'wait' metrics, cpu, physical i/o, memusage, open_tran, status, etc...
Heck, you could load this into a table every 2 seconds or so and then watch the trends...
What exactly are you trying to monitor?
"Keep Your Stick On the Ice" ..Red Green
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply