By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,795 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,795 IT Pros & Developers. It's quick & easy.

Server connection from client enterprise manager - slow

P: n/a
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
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Jul 20 '05 #2

P: n/a
> 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,
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.