michaelpg
asked on
Find high IO process
Hi There
How would one track down the SPID's in the database that are busiest, that is consuming the most CPU and IO resources ?
sp_who is not helpfull, it will tell you these stats for a process since connecting, but in my circumstance the app servers have connections to the database permanantly. Therefore sp_who stats reflect CPU and IO usage since being connected.
I have a problem where the CPU and IO's on my database server will go through the roof occasionally , and i dont know how to track down the SPID or process(or processes) that are the one's responsible.
Please help.
Thanx
How would one track down the SPID's in the database that are busiest, that is consuming the most CPU and IO resources ?
sp_who is not helpfull, it will tell you these stats for a process since connecting, but in my circumstance the app servers have connections to the database permanantly. Therefore sp_who stats reflect CPU and IO usage since being connected.
I have a problem where the CPU and IO's on my database server will go through the roof occasionally , and i dont know how to track down the SPID or process(or processes) that are the one's responsible.
Please help.
Thanx
You can use the Windows performance monitor.
ASKER
Could you please elaborate ?
I can know how to use it to track a windows process but not one of the processes in Sql Server ?
Thanx
I can know how to use it to track a windows process but not one of the processes in Sql Server ?
Thanx
ASKER
Hi Ben
I am familiar with all of this, this however does not provide you will statistics for 1 individual Sql Server Process ID ???
Thanx
I am familiar with all of this, this however does not provide you will statistics for 1 individual Sql Server Process ID ???
Thanx
If you need more detail, then SQL Profiler should be what you need.
ASKER
True, i just thought there was a better way ?
I have yet to see a CPU stat in profiler that is NOT 0, so i do not really trust profiler when it comes to CPU usage for a process id ?
I will leave this post here and see if maybe some else has a good idea, but thanx for the help Ben.
I have yet to see a CPU stat in profiler that is NOT 0, so i do not really trust profiler when it comes to CPU usage for a process id ?
I will leave this post here and see if maybe some else has a good idea, but thanx for the help Ben.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.