473,706 Members | 5,882 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Enterprise Manager takes 10+ min to open

Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?

Oct 23 '06 #1
6 2033
What version of SQL are you using? Also indicate the service pack
please.

Johnny Ruin wrote:
Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?
Oct 23 '06 #2
Johnny,

You can start a profiler session, start EM, and just observe what is
going on under the hood.

-----------------------
Alex Kuznetsov
http://sqlserver-tips.blogspot.com/
http://sqlserver-puzzles.blogspot.com/

Oct 23 '06 #3

"Johnny Ruin" <sc**********@g mail.comwrote in message
news:11******** **************@ h48g2000cwc.goo glegroups.com.. .
Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?
For one thing make sure you don't have the databases set to autoclose.

That can take a long time.
>

Oct 24 '06 #4
Hi everyone,

Thanks for your replies. I checked the version on the production
machine, it's "Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) "

The profiler idea was a good one. EM goes through it's 16 lines of
'get config stuff' that it does every time it starts, but then it
executes the following query many times. I didn't count the times,
but it looks like it's once per database.

select name, DATABASEPROPERT Y(name, N'IsDetached'),
(case when DATABASEPROPERT Y(name, N'IsShutdown') is null then -1 else
DATABASEPROPERT Y(name, N'IsShutdown') end),
DATABASEPROPERT Y(name, N'IsSuspect'),
DATABASEPROPERT Y(name, N'IsOffline'),
DATABASEPROPERT Y(name, N'IsInLoad'),
(case when DATABASEPROPERT Y(name, N'IsInRecovery' ) is null then -1 else
DATABASEPROPERT Y(name, N'IsInRecovery' ) end),
(case when DATABASEPROPERT Y(name, N'IsNotRecovere d') is null then -1
else DATABASEPROPERT Y(name, N'IsNotRecovere d') end),
DATABASEPROPERT Y(name, N'IsEmergencyMo de'),
DATABASEPROPERT Y(name, N'IsInStandBy') ,
has_dbaccess(na me), status, category, status2 from
master.dbo.sysd atabases

As I paged through the profiler output (can't seem to make that filter
thing work correctly) I realized that a) there's a lot going on this
machine and b) I haven't got a basic sql performance monitoring in my
skill set. I'll work toward that and I'll checkout auto close too.
Thanks again.

On Oct 23, 7:01 pm, "Greg D. Moore \(Strider\)"
<mooregr_delete t...@greenms.co mwrote:
"Johnny Ruin" <schafer.d...@g mail.comwrote in messagenews:11* *************** ******@h48g2000 cwc.googlegroup s.com...
Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?For one thing make sure you don't have the databases set to autoclose.

That can take a long time.

Oct 24 '06 #5
Johnny Ruin wrote:
Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?
Go in Options and uncheck the "Server state polling" option in the
General tab. Also in you server registration uncheck the "Display SQL
Server state in console" option.

Regards,
lucm

Oct 24 '06 #6
Thanks for your replies. I checked the version on the production
machine, it's "Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) "
This is the RTM (unpatched) release of SQL Server. I strongly suggest you
consider upgrading to SP4.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Johnny Ruin" <sc**********@g mail.comwrote in message
news:11******** **************@ i42g2000cwa.goo glegroups.com.. .
Hi everyone,

Thanks for your replies. I checked the version on the production
machine, it's "Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug
6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) "

The profiler idea was a good one. EM goes through it's 16 lines of
'get config stuff' that it does every time it starts, but then it
executes the following query many times. I didn't count the times,
but it looks like it's once per database.

select name, DATABASEPROPERT Y(name, N'IsDetached'),
(case when DATABASEPROPERT Y(name, N'IsShutdown') is null then -1 else
DATABASEPROPERT Y(name, N'IsShutdown') end),
DATABASEPROPERT Y(name, N'IsSuspect'),
DATABASEPROPERT Y(name, N'IsOffline'),
DATABASEPROPERT Y(name, N'IsInLoad'),
(case when DATABASEPROPERT Y(name, N'IsInRecovery' ) is null then -1 else
DATABASEPROPERT Y(name, N'IsInRecovery' ) end),
(case when DATABASEPROPERT Y(name, N'IsNotRecovere d') is null then -1
else DATABASEPROPERT Y(name, N'IsNotRecovere d') end),
DATABASEPROPERT Y(name, N'IsEmergencyMo de'),
DATABASEPROPERT Y(name, N'IsInStandBy') ,
has_dbaccess(na me), status, category, status2 from
master.dbo.sysd atabases

As I paged through the profiler output (can't seem to make that filter
thing work correctly) I realized that a) there's a lot going on this
machine and b) I haven't got a basic sql performance monitoring in my
skill set. I'll work toward that and I'll checkout auto close too.
Thanks again.

On Oct 23, 7:01 pm, "Greg D. Moore \(Strider\)"
<mooregr_delete t...@greenms.co mwrote:
>"Johnny Ruin" <schafer.d...@g mail.comwrote in
messagenews:11 *************** *******@h48g200 0cwc.googlegrou ps.com...
Hi,
I've got a machine with about 750 databases on it, and growing.
Enterprise Manager is very slow coming up on this machine and I was
wondering what I could do about it. What's it doing, connecting to
every database?For one thing make sure you don't have the databases set
to autoclose.

That can take a long time.

Oct 26 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
6151
by: Adam Ryan | last post by:
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.
1
1666
by: Thomas Richards | last post by:
Hi, I have a table with about 70k rows. When I use open table --> return all rows and then edit a field Enterprise Manager then says it has to return the entire result set for the update to take place. This can take a long time and makes editing data a slow process. Is there any way to get Enterprise Manager just to update the one row?? Thanks Tom
0
1533
by: Michael Bourgon | last post by:
Here's something I found a few months ago, and it seems to come in handy pretty often, so I figured I'd share. Disclaimer: you are modifying a SYSTEM TABLE. This may not work in the next version of SQL Server. When you right click on a Database in the Enterprise Manager and choose Properties, in order to show the last backup time, it has to go through MSDB and find the last backup date for the database. Unless you're carefully...
1
1390
by: John Morgan | last post by:
I am using a dial up connection to the Internet and to an online SQL Server database. I have a problem in that when I use Enterprise Manager to access even my local server , or even, it appears, when it is just open with no connection to any SQL Server, I experience very slow data transfer over my normal dial up connection. I am reasonably sure it is Enterprise Manager causing the problem as when I close it and redial I have an...
0
4543
by: Zorba.GR | last post by:
IBM DB2 Connect Enterprise Edition v8.2, other IBM DB2 (32 bit, 64 bit) (MULTiOS, Windows, Linux, Solaris), IBM iSoft Commerce Suite Server Enterprise v3.2.01, IBM Tivoli Storage Resource Manager Express Edition v1.3.2 Win, IBM Tivoli System Automation v1.2.0 Linux, IBM Tivoli Workload Scheduler Virtualized Data Centers v8.2 , other IBM Tivoli CDs, WEBSPHERE EVERYPLACE MOBILE PORTAL v5.0 - ALTIUM , other IBM WebSphere Business CDs...
2
2274
by: AH | last post by:
Dear all, I am facing this 'bug' that really drive me nut. I created a trigger for Update script and tested in Enterprise manager to ensure it function correctly. However, when I used both VB or Server explorer to update the table, it gives me error, Couldn't VB just act as a intermidary to make the call and SQL server is supposed to do all the jobs?? To explain it in a simple way, I have 3 TABLES, TABLE1 with column C1(key), C2(char) & C3...
2
3224
by: Benzine | last post by:
I am running MS SQL 2000. I recently ran a procedure in Query Analyzer from the Master db to clear out all replication information so I could start/recreate it again. After I ran this procedure Enterprise Manager no longer showed the registered server in the tree. When I tried to re-register it gave me the following message:
1
4554
by: chudson007 | last post by:
Hi All, What are the pros and cons between using Enterprise Manager or Query Analyzer for my queries. Currently I use Enterprise Manager because I prefer the interface and only use Query Analayzer when queries time out in Enterprise Manager, but I'm sure there must be more to it. Regards,
2
2082
by: grant | last post by:
Man do I struggle with Enterprise Manager as a graphical tool for building views etc. Its flaky and hangs frequenlty so i have to kill it with the task manager and re open it. You cant debug functions ( or am I missing something) But the worst thing is that it appears to cache the results of views and doesnt refresh from the source.
0
8780
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9285
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9155
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6614
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5938
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4445
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4708
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3145
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2499
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.