I have a problem with Enterprise Manager - when I refresh list of tables or
databases it hangs (is not responding) for long time - about 10-30 minutes.
What is more important during my refreshement users are unable to work
normally - it hangs entire server.
Some other details:
1. I am only dbo of one database with no administrative privilges.
2. There are no problems with Query Analyzer
3. Problem is related to one particular server - I don't have these
difficulties with my local instance of SQL Server.
Is there any solution of this problem?
Cheers.
7  2895 
Mr Curious (co******@somew here.eu) writes: I have a problem with Enterprise Manager - when I refresh list of tables
or databases it hangs (is not responding) for long time - about 10-30
minutes.
What is more important during my refreshement users are unable to work
normally - it hangs entire server.
Some other details:
1. I am only dbo of one database with no administrative privilges.
2. There are no problems with Query Analyzer
3. Problem is related to one particular server - I don't have these
difficulties with my local instance of SQL Server.
Sounds like there are several databases that are set to autoclose. Then
EM needs to open all of those, to see what permissions you have in them.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
Uzytkownik "Erland Sommarskog" <es****@sommars kog.se> napisal w wiadomosci
news:Xn******** **************@ 127.0.0.1... Mr Curious (co******@somew here.eu) writes: I have a problem with Enterprise Manager - when I refresh list of tables
or databases it hangs (is not responding) for long time - about 10-30
minutes.
What is more important during my refreshement users are unable to work
normally - it hangs entire server.
Some other details:
1. I am only dbo of one database with no administrative privilges.
2. There are no problems with Query Analyzer
3. Problem is related to one particular server - I don't have these
difficulties with my local instance of SQL Server.
Sounds like there are several databases that are set to autoclose. Then
EM needs to open all of those, to see what permissions you have in them.
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Thank you. Can I (or rather a server administrator) change this option? Is
it safe?
Regards.
Mr Curious (co******@somew here.eu) writes: Thank you. Can I (or rather a server administrator) change this option? Is
it safe?
Yes. Autoclose is a very dubious option. There are some contexts where
it's good, but not many.
I believe that Autoclose is on by default in MSDE instances. Where it may
make sense, because the database is only accessed from an application that
is run infrequently. But as soon as you start to access the server with
Enterprise Manager, autoclose becomes a problem. (Note that the license
terms does not permit you to access MSDE from EM!)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx Yes. Autoclose is a very dubious option. There are some contexts where
it's good, but not many.
I believe that Autoclose is on by default in MSDE instances. Where it may
make sense, because the database is only accessed from an application that
is run infrequently. But as soon as you start to access the server with
Enterprise Manager, autoclose becomes a problem. (Note that the license
terms does not permit you to access MSDE from EM!)
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Thank you again. This is not MSDE of course. I'll try to find out somethig
about this option (how to switch off etc.).
Cheers.
> Yes. Autoclose is a very dubious option. There are some contexts where it's good, but not many.
I believe that Autoclose is on by default in MSDE instances. Where it may
make sense, because the database is only accessed from an application that
is run infrequently. But as soon as you start to access the server with
Enterprise Manager, autoclose becomes a problem. (Note that the license
terms does not permit you to access MSDE from EM!)
One remark - if Auto close option is responsible - the server administrator
should have similair problem?
As far as I know he doesn't (I forgot to mention). That's why I suspect some
security issue.
Cheers.
Mr Curious (co******@somew here.eu) writes: One remark - if Auto close option is responsible - the server
administrator should have similair problem?
As far as I know he doesn't (I forgot to mention). That's why I suspect
some security issue.
I think the problem is due to that EM accesses the databases to see if you
have permission to it. Since sa has permission to all databases anyway,
EM might bypass the check for him.
The command to turn it off is ALTER DATABASE db SET AUTO_CLOSE OFF.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server 2005 at http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx
>> One remark - if Auto close option is responsible - the server administrator should have similair problem?
As far as I know he doesn't (I forgot to mention). That's why I suspect
some security issue.
I think the problem is due to that EM accesses the databases to see if you
have permission to it. Since sa has permission to all databases anyway,
EM might bypass the check for him.
The command to turn it off is ALTER DATABASE db SET AUTO_CLOSE OFF.
Thank you very much. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: PF |
last post by:
On one of our machines, all of the SQL Server 2000
components except for the main Server component (SQL Server
core) itself were installed (Management tools, etc) a while ago
and everything was running fine. Now I go and add/install the
Server component and then Service Pack 3a.
It seems that Service Manager won't start up (I get an hourglass cursor)
and now I find that Enterprise Manager won't run as well. No error
messages appeared...
|
by: bitunwise |
last post by:
I had a problem today where I could not see column names and all
tables had a _1 after them when viewing a Sql Server view in
Enterprise Manager
e.g.
TableName Company when added to the view would be named Company_1 and
the only columns available were 1 which was *(All Columns)
After looking through the news groups I saw several occurrences of
|
by: John Morgan |
last post by:
I have Enterprise Manager on my local machine. For the last twelve
months it has been connecting without problem to my online SQL Server
database provided by my ISP.
Three weeks ago the ISP applied some sort of extra security
arrangements to their SQL Server to allow access only through port
1433. they have told me to configure an alias using Network Client and
to register this alias in the usual way using my Enterprise Manager.
My...
|
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...
|
by: mikew |
last post by:
I am working at a company that has been using MS SQL Server, and we are going to be switching over to postgresql next week. (Getting off of Windows will be a relief!)
I am very familiar with SQL Server's "Enterprise Manager", which is their GUI for accessing the db. I have been acquainting myself with pgAdmin. There are a number of things that I really like about pgAdmin, but there are a few things that SQL Server Enterprise manager can...
| | |
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...
|
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...
|
by: mirzausce |
last post by:
Accuired eServer i5 570 - Enterprise Edition; questions..
--------------------------------------------------------------------------------
My company just purchased this unit from a company that went under.
It's brand new in the box and the configuration is posted below. We got
it for very cheap and are wondering if some of you that work with
mashines like this could give me some info on it. We are possibly
interested in implementing...
|
by: Alex |
last post by:
Hi Everyone,
Most of our MS SQL Servers are still running on SQL 2000, but being I
will soon be upgrading my workstation to Vista Business I'd like to
install MS SQL 2005 Enterprise Manager to manage them all. When I
tried to install MS SQL 2000 Enterprise Manager on Vista, it gave me a
message saying it's not compatible, so I'll have to use 2005 I guess.
We have LOTS of DTS scripts on our SQL 2000 server, and will 2005 EM
work with...
|
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,
|
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...
| | |
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...
|
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...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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...
|
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...
|
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
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
