Looooong Delays Connecting with Enterprise Mgr

Ever since upgrading to SQL Server 2000, connecting to the DB servers with
Enterprise Manager results in multi-minute delays while the database list
populates.
Is there something that can be done to make the connection process faster?Hi,
I think this will be the problem with one machine. Can you try with a
diffrent PC incase if it is faster then you can,
1. backup the OS login profile you are using
2. Delete the profile
3. Restore the profile back.
I had the same problem before and got solved after performing the above
steps.
Thanks
Hari
MCDBA
"R.MacLean" <zzz@.nospam.com> wrote in message
news:WSq2c.29720$aZ3.25484@.fed1read04...
> Ever since upgrading to SQL Server 2000, connecting to the DB servers with
> Enterprise Manager results in multi-minute delays while the database list
> populates.
> Is there something that can be done to make the connection process faster?
>|||Check the version of SQL 2000 that you are running. Verify that the
problem still occurs with SQL sp3a installed.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I have two machines here that connect to 8 different SQL Server machines.
No real difference between them -- looong delays after clicking to open the
Databases folder after connecting, regardless of which client machine or
which server I'm connecting to.
(I think I was able to reduce the delay connecting to one of the local
servers by taking most of the DBs offline.)
I suspect that SQL Server 2000 returns the stats for ALL of the DBs upon
opening the Databases folder, where SQL Server 7 didn't return the stats for
ANY of the DBs until you attempted to open the DB. 2000 lets you click
around between DBs more quickly after the DB info is returned, but this is
far inferior to the older system.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:OBrnvP$AEHA.212@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I think this will be the problem with one machine. Can you try with a
> diffrent PC incase if it is faster then you can,
> 1. backup the OS login profile you are using
> 2. Delete the profile
> 3. Restore the profile back.
> I had the same problem before and got solved after performing the above
> steps.
> Thanks
> Hari
> MCDBA
>
> "R.MacLean" <zzz@.nospam.com> wrote in message
> news:WSq2c.29720$aZ3.25484@.fed1read04...
with
list
faster?
>