Re: Enterprise Manager Slow
From: satyaki (satyaki_at_discussions.microsoft.com)
Date: 11/05/04
- Next message: JessicaSwe: "Multiple Applications on a SQL Server."
- Previous message: CC&JM: "DBCC SHOWFILESTATS"
- In reply to: Dejan Sarka: "Re: Enterprise Manager Slow"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 5 Nov 2004 01:44:02 -0800
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.
>
>
>
- Next message: JessicaSwe: "Multiple Applications on a SQL Server."
- Previous message: CC&JM: "DBCC SHOWFILESTATS"
- In reply to: Dejan Sarka: "Re: Enterprise Manager Slow"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
