Sql Server getting down after some time and then need restart

• guptahiman123

  Grasshopper

  Points: 20

  More actions

  January 9, 2014 at 1:59 pm

  #302989

  Hello friends,

  I have installed SQLEXPRADV_x64_ENU.exe in Windows Server 2012. I have launched an intranet web application referencing the database in the SQL server. Problem SQL server becomes unresponsive after some days. So as the result website also becomes unresponsive. It needs restart every time for correct functioning.

  I checked the logs. All the information i could find was the message:

  "XXX database is starting". Not able to figure out why ;-). Please help!!

• Ravid_ds

  Ten Centuries

  Points: 1149

  More actions

  January 9, 2014 at 8:47 pm

  #1679030

  Hi ,

  I don't think anyone would be able to answer right away, as there is very less information you have provided with an open wided question.

  Are you the inhouse DBA?

  If so when your mentioning as slow did you try to find out if there was any resource issue?

  What kind of configuration the server is running on? Need to identify what queries are picking most of the resource

  Please provide more details