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.
>
>

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/techin...n/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/techin...n/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.
>
>

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/techinfo/tips/administration/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/techinfo/tips/administration/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.
>
>

Enterprise Manager is not displaying any database information.

We have SQL 2000 Active/Active 2 node cluster. Yesterdat
we did a memory switch to use more than 2GB RAM after that
Enterprise Manager on one node is not displaying any
database information. All the databases is up its just
Enterprise Manager piece is not working. If I do clink on
new database thru ENterprise Manage It display following
message. Any idea ..
Error 220: Airthmetic overflow error for datatype
smallint, value = 32891Hi Avnish,
Try this:
From Query Analzyer, run this query:
use master
go
select * from sysdatabases
go
Do you get the same error?
Sincerely,
Yih-Yoon Lee [Microsoft]
Microsoft SQL Server Support
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.