Link to home
Create AccountLog in
Avatar of ec3008
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
ASKER CERTIFIED SOLUTION
Avatar of ptjcb
ptjcb
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account