Post reply

Performance Of THe Server

  • September 2, 2003 at 2:28 pm

    #160754

    I have been having some problems with overall performance of my server.

    1- It takes a long tine to connect when I first start up SQL.

    2- When I want to open a database to see the tables it can take up to 10 secs

    3- And when I to script a table of 3 columns it take up to one minute.

    4- etc, etc, etc

    Is there anything I can do?

  • September 2, 2003 at 2:56 pm

    #472262

    What edition of sql are you using? I think Personal Edition closes the databases when the last connection to the database ends.

    Have you got the database option 'autoclose' checked? If so the sql server has to open the database for the first connection.

    Steven

  • September 3, 2003 at 2:09 am

    #472318

    Check the SQL Server Logs to see what is happening when you are opening the database. If you see a lot of messages saying "Starting up database XYZ" then the database is set to auto-close. It does this to reduce resource usage.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 9, 2003 at 9:02 am

    #473228

    Is this happening only in EM or also in QA?

    If it is only happening in Em check your path settings.

    C:\Program Files\Microsoft SQL Server\MSSQL\Binn should be in you path.



    Bye
    Gabor

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

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