Post reply

slow browse enterprise manager

  • October 8, 2003 at 4:34 am

    #82793

    I have a sqlserver 2000 and more than 25 database in the same server.

    When I browse with the enterprise manager or to list the database name in quey analizer is very very slow (1-2 min.).

    No problem when i execute a query in ado or in query analyzer.

    I think that the problem is too many database/object, but there is a method to improve it?

    Thanks

  • October 8, 2003 at 5:52 pm

    #477652

    Check if you have the auto-close option set. When you expand the databases folder in EM, it will check the status of each database. If they are set to auto-close, it will need to startup the database so it can check the status. You will also see a lot of 'starting database ...' type messages in the log.

    Hope this helps

    Phill Carter

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

    Colt 45 - the original point and click interface

    Edited by - phillcart on 10/08/2003 6:01:05 PM

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

Viewing 2 posts - 1 through 1 (of 1 total)

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