big problems with MMC Console

[Klaus]

hi @ll

we have a couple of sql server and by one server we have big problems with
the
enterprise console (MMC). We use the MMC console on our client and to load
the Item "Database" the console need more as 2 min
on all other server the load is done in 5-10sec.

DNS looks fine
Wins looks fine
Windows Authentification looks fine

has anybody a idea what's wrong?

klaus

[Mike Epprecht (SQL MVP)]

Hi

Check that the databases are not set to "Auto Close" as this really impacts
the iteration of databases on the server.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mi...@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"Klaus" <klaus....@c-s-l.biz> wrote in message
news:OOkN7gdN...@TK2MSFTNGP15.phx.gbl...