Post reply

SQl Server log displays Starting up the database as the message and source as SPID34s

  • June 8, 2010 at 2:12 pm

    #233471

    One database keeps on starting up every few seconds and as a result the performance of the system is really low. Just to let you guys know, I am using Full Text Index search on that database. Can anyone tell me what is the problem and why does it try to start the database every few seconds?

    Thanks in advance

    Punit

  • June 8, 2010 at 2:23 pm

    #1177672

    Here is a link to a fourm thread with some information on this that may be helpful.

    http://www.sqlservercentral.com/Forums/Topic351864-5-1.aspx

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • June 9, 2010 at 12:01 am

    #1177806

    Is auto_close enabled?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 9, 2010 at 12:50 am

    #1177815

    You should check the auto close properties of the database.

    Auto Close should not be enabled for the database which is used frequently. Because auto close with close the database when there is no active transaction.

  • June 9, 2010 at 1:16 pm

    #1178200

    Thanks everyone..auto close was enabled and disabling it actually helped me solve the problem..

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply