Post reply

slow startup

  • June 25, 2006 at 4:15 am

    #61262

    Hi guys,

    I am using SQL Server 2000 personal edition. Apparently it takes ages for my sql server to start uo and then open any selected database. Once I have crossed that part, its quick again.

    Somebody, told me to check error logs, under Management --> Current Activity --> SQL Server Logs. The current log's actually kind of big and I think there are more than 1 entry of same database starting again.

    I currently have 26 databases on my server. I would appreciate if somebody can let me know what can be the issue.

    Thanks

    Shams

  • June 27, 2006 at 1:59 am

    #645990

    Please check if Autoclose is ON for the database. do you see something like below.

    2006-06-27 13:26:01.22 spid55    Starting up database 'a'

    2006-06-27 13:26:05.29 spid55    Starting up database 'a'. 

    2006-06-27 13:26:06.12 spid55    Starting up database 'a'. 

     

     

  • June 27, 2006 at 2:23 am

    #645994

    Hi mate,

    Yep I do get the same message, apprently I get the starting message for the same database more than once!

    Thanks!

  • June 27, 2006 at 3:31 am

    #646002

    Looks like autoclose is ON for all those database.

    Try by turning the option OFF.

    use Enterprise Manager and right click on database. Go for Option tab and uncheck Auto Close.

    HTH

  • June 27, 2006 at 4:34 am

    #646014

    Hi mate,

    Worked like a charm! Thanks a lot!

     

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

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