Adam Ryan (ad*****@hotmail.com) writes:
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--
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,
so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp