Time out exceeded and sp_lock
I'm having the problem described here
http://support.microsoft.com/kb/308518/en-us
When checking current activity (E.Manager - sql2000) I get a time out.
No matter how many times I refresh I get the same.
I have run sp_lock but don't really understand the results.
There are a couple of SPids that appear many many many times! (user accounts). I'm not familiar with the application they are using so am not sure it is normal activity.
Mosty of the objectids are 1,2,3,...12 etc but one of them is 442102604 (how can I tell what this is? should I care? I only mention it as the number is astronomically higher than the others)
Under resource I have entries such as (4e00e7c9a11a) (what does this hex represent?)
Under mode what is Sch-M?
http://support.microsoft.com/kb/308518/en-us
When checking current activity (E.Manager - sql2000) I get a time out.
No matter how many times I refresh I get the same.
I have run sp_lock but don't really understand the results.
There are a couple of SPids that appear many many many times! (user accounts). I'm not familiar with the application they are using so am not sure it is normal activity.
Mosty of the objectids are 1,2,3,...12 etc but one of them is 442102604 (how can I tell what this is? should I care? I only mention it as the number is astronomically higher than the others)
Under resource I have entries such as (4e00e7c9a11a) (what does this hex represent?)
Under mode what is Sch-M?
Hi QPR,
Just realised that this is your question.
Cheers
David
Just realised that this is your question.
Cheers
David
ASKER
Hi David,
sp_who doesn't unearth much that I can see. Normal stuff, no locks... background/sleeping etc.
Anything in particular I should be looking for?
sp_who doesn't unearth much that I can see. Normal stuff, no locks... background/sleeping etc.
Anything in particular I should be looking for?
ASKER
and wouldn't you believe it! Now for the first time this morning I can see the current activity.
and now I have regained access (viewing properties etc) to tempDB.
Would a mass of activity have caused my previous problems do you think?
I'm not sure whether to shrug and move on or dig and try to prevent future probs?
and now I have regained access (viewing properties etc) to tempDB.
Would a mass of activity have caused my previous problems do you think?
I'm not sure whether to shrug and move on or dig and try to prevent future probs?
Hi,
In sp_who, where there any processes that had spun off additional threads? You've looked at the blocking. Those two can slow things down ...
Cheers
David
In sp_who, where there any processes that had spun off additional threads? You've looked at the blocking. Those two can slow things down ...
Cheers
David
ASKER
how would you ID these additional threads?
spid, ecid, status, login, host, blk,dbname, cmd
spid, ecid, status, login, host, blk,dbname, cmd
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, SPIDs were all unique so I'm putting it down to heavy DB use on an ageing server. Will use the info in future tho.
Initially sp_who is a little easier to interprit. Try that first and we can discuss your results.
Cheers
David