Server connection from client enterprise manager - slow

[Adam Ryan]

Hi,


I am seeing very slow connections from some client enterprise managers
to server. Even at server level it takes 1 minute or less to open a
database. I have adjusted some of the memory for the SQL server, but
there are only about 60 Dbs on the server, totalling about 2 GBs.

CPU is very low at all times, 1 GB of ram, p3 1.4Ghz. SQL 2k.

I know I should refrag the disk, but is there anything else I can do
to speed up SQL operation via enterprise manager--

ODBC connections is fairly fast, as well as query analyzer.


Adam

[Erland Sommarskog]

Re: Server connection from client enterprise manager - slow

Adam Ryan (adamr05@hotmai l.com) writes:[color=blue]
> I am seeing very slow connections from some client enterprise managers
> to server. Even at server level it takes 1 minute or less to open a
> database. I have adjusted some of the memory for the SQL server, but
> there are only about 60 Dbs on the server, totalling about 2 GBs.
>
> CPU is very low at all times, 1 GB of ram, p3 1.4Ghz. SQL 2k.
>
> I know I should refrag the disk, but is there anything else I can do
> to speed up SQL operation via enterprise manager--[/color]

Exactly what do you mean by "opening a database"?

On my workstation, I right-clicked on a database and started my stop-
watch as I clicked Properties. That took 10 seconds. I have SQL Server
running locally. Sure that is less than a minute, but it's still quite
some time.

I guess that since EM is an administration tool, that MS figured that if
it was a litle slow in places was not so much of an issue. It is not that
you have dozens and dozens of users connection from Enterprise Manager,
have you?


--
Erland Sommarskog, SQL Server MVP, sommar@algonet. se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Adam Ryan]

Re: Server connection from client enterprise manager - slow

> Exactly what do you mean by "opening a database"?

Via enterprise manager I expand the databases section and then get a
list of dbs. When I click further on another db, it takes an
extremely long time to open. And this is done locally not remotely.

Remotely connecting to the machine takes 10x as long. Most of the
time, there are time outs that cause a dropped connection.

I am assuming that there are about 2 connections with EM at all times.

Any more info you might have on how to speed connections with EM up?

Thanks,