Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
matt_calhoon
Posting Yak Master
235 Posts |
 Posted - 2005-08-15 : 07:43:06
|
| Hi there,My live sql box will not let me open up "Current Activity" from Enterprise Manager and comes up with "Error 1222: lock request time out period exceeded". I cannot re-index any databases and it times out. I cannot run DBCC CHECKDB as this times out as well, however running "Select" statements works.I ran the profiler to check locks but I couldn't really see any information from here though Im not a guru at reading how this works.Can anyone offer me some advice on how to troubleshoot this before I restart the services for SQL?Any support appreciated.thanks, matt. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-15 : 09:00:11
|
| run sp_lock and sp_who. look for blocking. use kill if you have to. profiler takes some practice and some reading but it is an awesome tool once you learn it.====================================================Regards,Sean RoussyThank you, drive through |
 |
|
|
|
|
|
lock request time out period exceeded