Sql Server is running very slow while at start up

• srivarun

  Newbie

  Points: 9

  More actions

  October 19, 2005 at 9:56 am

  #111961

  Hi All,

  Sql Server is running very slow while at start up.

  Please let me know if u have any idea.

  Regards,

  Srinivas

• Jo Pattyn

  SSC-Dedicated

  Points: 32578

  More actions

  October 19, 2005 at 10:00 am

  #598347

  Quite logical:

  1) Tempdb has to increase in size

  2) Databases are checked and all transactions that were running when the service was shutdown are being rolled forward/backward

  3)All buffers are being refilled (cache hit ratio)

  4)Execution plans of stored procedures are being rebuild.

  Can you see in the sql server logs what is happening?

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  October 24, 2005 at 11:44 am

  #599608

  What is the time of the first entry in the errorlog to the last in the errorlog at startup ?

  I ask because it varies from system to system ...

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."