March 5, 2017 at 9:43 pm
In what conditions the sql server will Hang on.How to resolve the Hanged sql server.
March 6, 2017 at 7:38 am
nagaraju.manavarthi - Sunday, March 5, 2017 9:43 PMIn what conditions the sql server will Hang on.How to resolve the Hanged sql server.
How do you know it's SQL Server itself hanging up on something? If you are having problems connecting, it could be whatever you are connecting with or a problem with how you are connecting. If you are sure there is something wrong with SQL Server, check the current error log. The name is ERRORLOG
Sue
March 6, 2017 at 8:06 am
Try connecting with the dedicated administration connection (DAC). This has reserved resources if the server is too busy to respond to normal user requests.
March 6, 2017 at 8:09 am
Steve Jones - SSC Editor - Monday, March 6, 2017 8:06 AMTry connecting with the dedicated administration connection (DAC). This has reserved resources if the server is too busy to respond to normal user requests.
Good pint. Didn't mention that since this was in the SQL 7, 2000 forum.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply