Sql server

• nagaraju.manavarthi

  Ten Centuries

  Points: 1005

  More actions

  March 5, 2017 at 9:43 pm

  #401736

  In what conditions the sql server will Hang on.How to resolve the Hanged sql server.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  March 6, 2017 at 7:38 am

  #1931793

  nagaraju.manavarthi - Sunday, March 5, 2017 9:43 PM

  In 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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  March 6, 2017 at 8:06 am

  #1931817

  Try connecting with the dedicated administration connection (DAC). This has reserved resources if the server is too busy to respond to normal user requests.

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  March 6, 2017 at 8:09 am

  #1931820

  Steve Jones - SSC Editor - Monday, March 6, 2017 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.

  Good pint. Didn't mention that since this was in the SQL 7, 2000 forum.

  Sue