Enterprise Manager - Database list hangs

I have this problem on a couple of machines, where when I expand the
Database list under the server (typically the local server, i.e. the one EM
is installed on) it takes a very long time to respond and sometimes hangs
for over 10 minutes.
The only KB article I could find was referring to a problem with a large
number of databases, whereas these only have about 10-20 databases on them.
I assume it's some sort of name resolution problem - any ideas how to debug
what's happening?
Paul
See of you have ODBC tracing turned on...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Paul Hatcher" <phatcher@.nospam.cix.co.uk> wrote in message
news:%23zkR9x0wFHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have this problem on a couple of machines, where when I expand the Database list under the server
>(typically the local server, i.e. the one EM is installed on) it takes a very long time to respond
>and sometimes hangs for over 10 minutes.
> The only KB article I could find was referring to a problem with a large number of databases,
> whereas these only have about 10-20 databases on them.
> I assume it's some sort of name resolution problem - any ideas how to debug what's happening?
> Paul
>
|||Tibor, thanks but no cigar - not turned on.
I'll try using the profiler any see if I can see anything - there's no
obvious CPU actvitity whilst it's hanging so I think it might be down to
networking issues of some sort.
Paul
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ObaZv60wFHA.720@.TK2MSFTNGP10.phx.gbl...
> See of you have ODBC tracing turned on...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Paul Hatcher" <phatcher@.nospam.cix.co.uk> wrote in message
> news:%23zkR9x0wFHA.2924@.TK2MSFTNGP15.phx.gbl...
>
|||Also make sure autoclose is turned off for the databases and
that you have applied the latest service packs on the client
where Enterprise Manager seems to hang. There were some
fixes for the issue you described in one of the service
packs.
-Sue
On Thu, 29 Sep 2005 10:24:30 +0100, "Paul Hatcher"
<phatcher@.nospam.cix.co.uk> wrote:

>Tibor, thanks but no cigar - not turned on.
>I'll try using the profiler any see if I can see anything - there's no
>obvious CPU actvitity whilst it's hanging so I think it might be down to
>networking issues of some sort.
>Paul
>"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
>message news:ObaZv60wFHA.720@.TK2MSFTNGP10.phx.gbl...
>
|||Paul
Check the service pack version of Enterprise Manager. There was a bug in an
earlier build (before sp3) where EM did a self join of sysdatabases, and if
that was combined with the autoclose option as Sue suggested, it could take
a LONG time to open the list. Make sure you check the version of the tools
on the client machine, not the version of the server. Sometimes people
forget to apply a sp to all the clients.
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Paul Hatcher" <phatcher@.nospam.cix.co.uk> wrote in message
news:%23zkR9x0wFHA.2924@.TK2MSFTNGP15.phx.gbl...
>I have this problem on a couple of machines, where when I expand the
>Database list under the server (typically the local server, i.e. the one EM
>is installed on) it takes a very long time to respond and sometimes hangs
>for over 10 minutes.
> The only KB article I could find was referring to a problem with a large
> number of databases, whereas these only have about 10-20 databases on
> them.
> I assume it's some sort of name resolution problem - any ideas how to
> debug what's happening?
> Paul
>