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 |
asarak
Starting Member
36 Posts |
Posted - 2005-12-07 : 06:52:38
|
Hi Guys, i ve got a problem.Suddenly while i was trying to get into the Enterprise Manager -- In the Current Activity, to see the locks i receive the following message:Error 1222, Lock request time out period exceeded.I am looking also to the log and saw the error:Error: 15457, Severity: 0, State: 1I am trying from the server console itself but there is the same effect... Some times work but others (mostly) failed...I also check the query timeout option in the server and i found that is about 600 ms (not 0 which is unlimited) but this was changed many months ago.Thanks a lotAny suggestions???RegardsAsarak |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-12-07 : 08:39:15
|
quote: Originally posted by asarak I am looking also to the log and saw the error:Error: 15457, Severity: 0, State: 1
This error appears when you open the server properties in Enterprise Manager. It's more informational than an actual error. I wouldn't worry too much about it.quote: Originally posted by asarak Suddenly while i was trying to get into the Enterprise Manager -- In the Current Activity, to see the locks i receive the following message:Error 1222, Lock request time out period exceeded.I also check the query timeout option in the server and i found that is about 600 ms (not 0 which is unlimited) but this was changed many months ago.
Do you mean the "query timeout" option in Query Analyzer? Mine's set to "0" and "lock time-out" is set to "-1".Do all queries time out? Are you the only one that is having time outs?Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-12-07 : 08:58:18
|
Short answer--don't use Current Activity monitor in SEM. It is known to cause these issues. Instead use the sp_who and sp_who2 system stored procs, or as I'm becoming more accustomed to, just select from master.dbo.sysprocesses directly.Jon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
|
|
asarak
Starting Member
36 Posts |
Posted - 2005-12-08 : 01:30:04
|
Thanks guys, i also use sp_who or sp_who2 and also make some select statements from sysprocesses and works fine... This morning i make a restart to the main production server just in case....Because we try the past days some defragmentation... I will check it also today and let you know... Thanks a lotBest RegardsASARAK |
|
|
|
|
|
|
|