Enterprise Manager performance

Not sure what category this belongs to, so sqlserver.server it is...
Anyway, I am experiencing signficant performance problems using SS2K
Enterprise Manager. Any action, including something as simple as expanding
the list of databases on a server takes takes an incredibly long time.
Some examples...
1. Expanding the database folder to show the databases on a server takes
upwards of 2 minutes to complete
2. Saving a DTS package takes upwards of 2 minutes
3. Opening up a DTS package, and then double clicking on a Transform Data
Task can take upwards of 5 minutes.
I am the only one in our group that is having these problems, and our dba is
at a loss. Any suggestions?
I am running WinXP SP1
What method are you using to connect to your SQL Server? TCP/IP, Named
Pipes, Shared Memory?
Perhaps you need to enable TCP/IP and connect that way...
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Glenn Coello" <Glenn Coello@.discussions.microsoft.com> wrote in message
news:99E9B96E-B46C-41CE-9D32-ED045594F0C2@.microsoft.com...
> Not sure what category this belongs to, so sqlserver.server it is...
> Anyway, I am experiencing signficant performance problems using SS2K
> Enterprise Manager. Any action, including something as simple as
> expanding
> the list of databases on a server takes takes an incredibly long time.
> Some examples...
> 1. Expanding the database folder to show the databases on a server takes
> upwards of 2 minutes to complete
> 2. Saving a DTS package takes upwards of 2 minutes
> 3. Opening up a DTS package, and then double clicking on a Transform Data
> Task can take upwards of 5 minutes.
> I am the only one in our group that is having these problems, and our dba
> is
> at a loss. Any suggestions?
> I am running WinXP SP1
|||This is a dumb question, but how do I tell? I added all of my servers via
the New SQL Server registration in Enterprise Manager. I don't get asked a
connection method, and there is no option to adjust that within any of my
Properties menus.
"Warren Brunk" wrote:

> What method are you using to connect to your SQL Server? TCP/IP, Named
> Pipes, Shared Memory?
> Perhaps you need to enable TCP/IP and connect that way...
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
> "Glenn Coello" <Glenn Coello@.discussions.microsoft.com> wrote in message
> news:99E9B96E-B46C-41CE-9D32-ED045594F0C2@.microsoft.com...
>
>
|||SQL 2005
http://msdn2.microsoft.com/en-us/library/ms190611.aspx
SQL 2000
http://www.verio.com/support/documen...fm?doc_id=4027
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Glenn Coello" <GlennCoello@.discussions.microsoft.com> wrote in message
news:F2CEF464-DA3F-42A5-850C-93573DD5FA96@.microsoft.com...[vbcol=seagreen]
> This is a dumb question, but how do I tell? I added all of my servers via
> the New SQL Server registration in Enterprise Manager. I don't get asked
> a
> connection method, and there is no option to adjust that within any of my
> Properties menus.
> "Warren Brunk" wrote:
|||Since you said you were using SQL Server 2000 and the EM, do the following:
Start -> All Programs -> SQL Server -> Client Network Utility -> General tab
You will want to check this on both the client and the server to see which
protocols are enabled on each.
At least this will get you the protocols enabled - I don't know about fixing
the solution to your problem however, sorry. This is one place to start, as
Warren mentioned.
"Glenn Coello" <GlennCoello@.discussions.microsoft.com> wrote in message
news:F2CEF464-DA3F-42A5-850C-93573DD5FA96@.microsoft.com...[vbcol=seagreen]
> This is a dumb question, but how do I tell? I added all of my servers via
> the New SQL Server registration in Enterprise Manager. I don't get asked
> a
> connection method, and there is no option to adjust that within any of my
> Properties menus.
> "Warren Brunk" wrote: