ec3008
asked on
waitresource explanation on sysprocesses (sql2000)
Hi,
on sqlserver2000 sp3 I've a problem with a job that hungs, on sysprocesses I find the spid in running with this lastwaittype PAGEIOLATCH_SH and this waitresource 5:3:93291.
The only thing that I can do is kill the spid.
My problem is that I don't know how mean this value (5:3:93291). I understand that the first number is db but what mean the other two numbers and how I can use this value to understand the problem
thanks
on sqlserver2000 sp3 I've a problem with a job that hungs, on sysprocesses I find the spid in running with this lastwaittype PAGEIOLATCH_SH and this waitresource 5:3:93291.
The only thing that I can do is kill the spid.
My problem is that I don't know how mean this value (5:3:93291). I understand that the first number is db but what mean the other two numbers and how I can use this value to understand the problem
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.