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 - 2004-01-29 : 07:56:55
|
| Mike writes "It would be appriciated if you can help on the following two scenarios...Scenario 1: Suppose assume that everybody on the application support broke a leg and is out on a Hospital so you're by yourself, when the client's manager calls you saying that the application is frozen and doesn't do any useful work, and asks you to try to fix it. You run the application from the development environment (Visual Studio) and it hangs on the very first call done to the database server. You manage to connect to the database server using SQL Enterprise Manager. What would you look at in Enterprise Manager now? Scenario 2: Same as above, but when you try to connect using SQL Enterprise Manager you can't, and it hangs too. It certainly doesn't look good, and you begin thinking about advising a reboot. Before you go to that length, you try to connect using SQL Query Analyzer, and you manage to do it. What would you do now to check what's hanging the database server, if you can only use SQL Query Analyzer to check the server's status?Thank you,Mike." |
|
|
MuadDBA
628 Posts |
Posted - 2004-01-29 : 08:32:19
|
| Those sound like test questions. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-01-29 : 08:50:34
|
| Run this proc and look at the result(never try to use enterprise manager on a server if you think somethings wrong - it'll probably make things worse)http://www.nigelrivett.net/sp_nrSpidByStatus.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Problem solving approach when server hangs