July 6, 2007 at 7:39 am
I periodically get periods of intense disk activity (on a reasonably fast SAN), to the point where users are impacted. I can see the disk usage pinning at 100% using the Windows performance monitor, but I don't know which jobs/databases are doing this.
What is the best way to find which process IDs are responsible for disk activity?
jay
...
-- FORTRAN manual for Xerox Computers --
July 6, 2007 at 9:09 pm
SQL Profiler
July 7, 2007 at 9:15 am
You can also query the sysprocesses table to check that.
July 8, 2007 at 11:44 pm
Since you have posted in 2000 forum you have options of profiler/sysprocesses/perfmon with sql server stats else if your server is 2005 you have DMVs that will give more details than these tools.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply