Enterprise Manager runs slow on some computers

I have a network of WinXP SP1 machines who all connect to
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Enterprise Manager runs slow on some computers

I have a network of WinXP SP1 machines who all connect to
SQL Server 2000 SP3 on a Win2k server. When running
enterprise manager, most of the computers take at least 4
minutes to expand the database tree. Working on databases
(retrieving properties etc) is also painfully slow. On
two computers, however, Enterprise Manager shows no
slowdown and work as I would expect. Can anyone assist me
in diagnosing the problem?
I would guess that one of the snap ins on the slower machines might be
causing a problem, I had something similar happen to me only for me the
enterprise manager wouldn't open at all.
On one of the slower machines try opening the Microsoft Management Console
program (C:\windows\system32\mmc.exe) and click on file and add/remove snap
ins. CLick the Add button and then select the Microsoft SQL Enterprise
manager. Click Ok and then try to open the database tree to see if its any
quicker. If so you can then click save as and use this console file instead
of the enterprise manager. If not then I'm afraid i can;t help you.
Nick
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check to ensure that the AutoClose properties of the databases are not set
in EM on the slow machines.
Andrew J. Kelly SQL MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
> I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Check for a file called SQL.LOG on the slow machines. If it's there and is
growing, you've got ODBC Tracing turned on.
Otherwise, run a network trace and compare the protocols being used from
the slow vs. fast.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Also, in EM, you can click on File|Options... and choose to delete the
history of changes to the console files. This can speed up performance as
well.
Jacco Schalkwijk
SQL Server MVP
"G. Sutherland" <g.sutherland@.REMOVEkildrummy.co.uk> wrote in message
news:5dbc01c474b6$da345870$a501280a@.phx.gbl...
>I have a network of WinXP SP1 machines who all connect to
> SQL Server 2000 SP3 on a Win2k server. When running
> enterprise manager, most of the computers take at least 4
> minutes to expand the database tree. Working on databases
> (retrieving properties etc) is also painfully slow. On
> two computers, however, Enterprise Manager shows no
> slowdown and work as I would expect. Can anyone assist me
> in diagnosing the problem?
|||Yes you fixed my prob-, SQL TRACING WAS TURNED ON.
I have a very fast computer and it still made E-P-M very slow alymost
unuseable... Found c:\sql.log file 2.5 GB's in size ha ha...
Turned Tracing off works very fast now. cool!
Hummm, Now to find out how it got turned on in the first place ? Who
did it did you ? why you little #&*&#?! get over here!
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Enterprise Manager over a VPN gets No items

I have an environment that has 18 separate SQL server machines. When
connected to the LAN I can connect to each and expand the databases tab no
problem. When I try the same over a VPN I find that three of my servers will
connect but on expanding the databases I get a long pause then 'No items'.
I've checked around and found some references to the same problem (SQL
server mag site) but no resolutions. I'm running XP pro and my SQL is sp3.
The three servers in question have only TCP and named pipes in the net lib,
they are all on Win2K one is on sp3, one on sp2 and one is 'out of the box'.
The VPN has ports 1433 and 1434 udp and tcp allowed.

Does anyone have any suggestions as to what is causing this, its got to be
something simple but I've been looking at this so long now I cant see the
wood for the trees.

Help appreciated.There is a least one known issue that can produce this:

http://support.microsoft.com/default.aspx?scid=kb;[LN];Q315523

Here are some comments from an MS engineer on it:

http://groups.google.ch/groups?hl=e...%40cpmsftngxa06

There are several Google groups hits on this, by the way:

http://groups.google.com/groups?hl=...ems&sa=N&tab=wg

Simon

"Simon" <spamplin@.hss.com> wrote in message
news:bdpe27$k71$1@.hercules.btinternet.com...
> I have an environment that has 18 separate SQL server machines. When
> connected to the LAN I can connect to each and expand the databases tab no
> problem. When I try the same over a VPN I find that three of my servers
will
> connect but on expanding the databases I get a long pause then 'No items'.
> I've checked around and found some references to the same problem (SQL
> server mag site) but no resolutions. I'm running XP pro and my SQL is sp3.
> The three servers in question have only TCP and named pipes in the net
lib,
> they are all on Win2K one is on sp3, one on sp2 and one is 'out of the
box'.
> The VPN has ports 1433 and 1434 udp and tcp allowed.
> Does anyone have any suggestions as to what is causing this, its got to be
> something simple but I've been looking at this so long now I cant see the
> wood for the trees.
> Help appreciated.

Enterprise manager is slow!

I have a number of machines connecting to SQL server.
When using Enterprise Manager, half of them take around 5
minutes to expand the database tree, while the other half
are fine. The only difference in the computer I can find
is that the slow ones are running Delphi. Is there a
known issue with EM and Delphi? If not, can anyone
suggest things I can try to sort out this problem?
"Graeme" <anonymous@.discussions.microsoft.com> wrote in message
news:1ba201c49a3e$27b13030$a501280a@.phx.gbl...
> I have a number of machines connecting to SQL server.
> When using Enterprise Manager, half of them take around 5
> minutes to expand the database tree, while the other half
> are fine. The only difference in the computer I can find
> is that the slow ones are running Delphi. Is there a
> known issue with EM and Delphi? If not, can anyone
> suggest things I can try to sort out this problem?
As a troubleshooting step, if you de-install Delphi on one of the problem
clients, then EM loads faster?
Steve

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
>