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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-12 : 08:03:44
|
| fabio writes "Sometimes, when I run a query involving many computing resources, my Sql Server engine remain in waiting, I mean I cannot open Current Activity, the alert message answers me about time-out joined. I can solve this problem only taking offline and then online the SQL Server in my Cluster Administrator Console. What can I do to avoid or to identify this catastrophical event?Thank you very much." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-06-12 : 08:13:07
|
| Well:-a) Get more memory for SQL..b) Make your queries more efficient - use the query plan for this...c) Check the locks via sp_lock and find out where the clash is...PeaceRick |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-06-12 : 17:57:38
|
| Because Enterprise manager uses tempdb for its current activity views it is very easy for it to be blocked and appear to hang under very moderate locking/blocking activity. Use sp_who2 and sp_lock to get a picture of what's going on. There's lots of scripts on the internet for various improvements on sp_lock (i.e. translating the objectid's)HTHJasper Smith |
|
|
|
|
|
|
Locks and Curent Activity