Enterprise Manager?

I have a new windows 2003 SBS server installation and an
application that requires SQL server. How do I get to the
Enterprise Manager to configure SQL?Is SQL Server installed? It should be in Programs > Micorsoft SQL Server >
Enterprise Manager
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Vince" <anonymous@.discussions.microsoft.com> wrote in message
news:03aa01c3b849$9258ea90$a101280a@.phx.gbl...
> I have a new windows 2003 SBS server installation and an
> application that requires SQL server. How do I get to the
> Enterprise Manager to configure SQL?|||NO SQL server is not installed. How is it installed?
>--Original Message--
>Is SQL Server installed? It should be in Programs >
Micorsoft SQL Server >
>Enterprise Manager
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>
>"Vince" <anonymous@.discussions.microsoft.com> wrote in
message
>news:03aa01c3b849$9258ea90$a101280a@.phx.gbl...
>> I have a new windows 2003 SBS server installation and an
>> application that requires SQL server. How do I get to
the
>> Enterprise Manager to configure SQL?
>
>.
>|||> NO SQL server is not installed. How is it installed?
setup.exe, from the installation CD?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Enterprise Manager very slowly

Hi,
Is there any parameters to configure to improve the performance in the
Enterprise Manager ? I have installed 7 small databases but when I click in
the "Databases" option, for example, I need to wait for several seconds (I
don´t think this is right). There are other options with the same problem.
It´s occur and my two machines (and I already see this in other machines),
the first running Windows 2003 Server Standard RC2 and the second running
Windows XP Professional, both with SQL Server 2000 - SP3.
Any suggest ?
Vitor Mauricio de N. Silva
Rio de Janeiro - BrazilVitor
Have you check odbc trace is running?
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:eYpFr1OSDHA.2132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any parameters to configure to improve the performance in the
> Enterprise Manager ? I have installed 7 small databases but when I click
in
> the "Databases" option, for example, I need to wait for several seconds (I
> don´t think this is right). There are other options with the same problem.
> It´s occur and my two machines (and I already see this in other machines),
> the first running Windows 2003 Server Standard RC2 and the second running
> Windows XP Professional, both with SQL Server 2000 - SP3.
> Any suggest ?
> Vitor Mauricio de N. Silva
> Rio de Janeiro - Brazil
>|||Perfect. I had some databases with the option AUTO CLOSE clicked. After
changed everything works fine.
Thanks,
Vitor Mauricio de N. Silva
Rio de Janeiro - Brazil
"Vitor Mauricio de N. Silva" <vitor_mauricio@.terra.com.br> wrote in message
news:eYpFr1OSDHA.2132@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Is there any parameters to configure to improve the performance in the
> Enterprise Manager ? I have installed 7 small databases but when I click
in
> the "Databases" option, for example, I need to wait for several seconds (I
> don´t think this is right). There are other options with the same problem.
> It´s occur and my two machines (and I already see this in other machines),
> the first running Windows 2003 Server Standard RC2 and the second running
> Windows XP Professional, both with SQL Server 2000 - SP3.
> Any suggest ?
> Vitor Mauricio de N. Silva
> Rio de Janeiro - Brazil
>

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