Enterprise Manager Slow

We have a SQL Server 2000 loaded on a server with 2 Xeon CPU & 2 GB of RAM.
SQL server is configure to use all the CPU & 1.5 GB of RAM. This SQL server
is acting as a repositary database for all the locational data. No of
databases on the server is 95 including master, model, msdb will be 120+
within next few months. Average database size is 2GB per database, where as
one database is of 40GB+.
My problem is whenever I try to open the database list on Enterprise manager
either in the server or in my pc it takes 10 to 15 minutes to open. where as
in query analyzer there is no issue.
Can anybody help me how i can improve the performance of Enterprise manager.
Thanks.
Check whether you have turned on the "Autoclose" option in your databases.
(http://www.microsoft.com/sql/techinf.../autoclose.asp).
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"satyaki" <satyaki@.discussions.microsoft.com> wrote in message
news:6840A2F2-AD5E-4B3A-9B80-57FB5917381C@.microsoft.com...
> We have a SQL Server 2000 loaded on a server with 2 Xeon CPU & 2 GB of
RAM.
> SQL server is configure to use all the CPU & 1.5 GB of RAM. This SQL
server
> is acting as a repositary database for all the locational data. No of
> databases on the server is 95 including master, model, msdb will be 120+
> within next few months. Average database size is 2GB per database, where
as
> one database is of 40GB+.
> My problem is whenever I try to open the database list on Enterprise
manager
> either in the server or in my pc it takes 10 to 15 minutes to open. where
as
> in query analyzer there is no issue.
> Can anybody help me how i can improve the performance of Enterprise
manager.
> Thanks.
|||Thanks a lot. it works.
"Dejan Sarka" wrote:

> Check whether you have turned on the "Autoclose" option in your databases.
> (http://www.microsoft.com/sql/techinf.../autoclose.asp).
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "satyaki" <satyaki@.discussions.microsoft.com> wrote in message
> news:6840A2F2-AD5E-4B3A-9B80-57FB5917381C@.microsoft.com...
> RAM.
> server
> as
> manager
> as
> manager.
>
>