Enterprise Manager Freezing up

Hi,
When I try to browse databases within Enterprise Manager on my SQL server,
the machine freezes up. It takes like 20 minutes to just see the list of
databases on the server.
Any ideas what's wrong and how to fix it.
thanks
rafaelAre you running any jobs on it or doing anything like rebuilding indexes?
Could be low on resources - not sure though, you didn't give any specs or
specific info. You can use Profiler to analyze further.
"Rafael Chemtob" <rchemtobb@.nospam.yahoo.com> wrote in message
news:umS%23fW4SFHA.3652@.TK2MSFTNGP15.phx.gbl...
> Hi,
> When I try to browse databases within Enterprise Manager on my SQL server,
> the machine freezes up. It takes like 20 minutes to just see the list of
> databases on the server.
> Any ideas what's wrong and how to fix it.
> thanks
> rafael
>|||If the DB's are set to autoclose, EM has to ask each one to start up to find
out it's properties. Check the SQL Event log for DB startup messages.
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/
"Rafael Chemtob" <rchemtobb@.nospam.yahoo.com> wrote in message
news:umS%23fW4SFHA.3652@.TK2MSFTNGP15.phx.gbl...
> Hi,
> When I try to browse databases within Enterprise Manager on my SQL server,
> the machine freezes up. It takes like 20 minutes to just see the list of
> databases on the server.
> Any ideas what's wrong and how to fix it.
> thanks
> rafael
>