Tuesday, March 20, 2012

big problems with MMC Console

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
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: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Klaus" <klaus.bilger@.c-s-l.biz> wrote in message
news:OOkN7gdNFHA.3772@.TK2MSFTNGP15.phx.gbl...
> 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
>

No comments:

Post a Comment