Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dave123
Starting Member
3 Posts |
 Posted - 2003-07-09 : 13:53:00
|
| This may be off topic for this forum, so my apologies if it is.I am a website developer and use Enterprise Manager to connect to SQL Server Databases at several host providers.99.9% of the time when I connect to SQL Server and click on the databases folder to retrieve the list of databases, I get the list of databases. Normally it takes less than 15 seconds to get this list.In 1 instance, 1 certain host provider, when I click on the databases folder to get the list of databases, it NEVER provides me a list of the databases. It only gives me "No Items". Everytime! I then have to right-click on the folder and click refresh, which takes "an eternity" to get the list of databases. I am talking 10 to 15 minutes to get the list of databases. And, they don't have anymore databases on this server than the other host providers.I contacted the host provider and they acted like it was nothing and that is how it works.Why do I have to click refresh for only this one host provider? Does it have something to do with their SQL Server configuration? Is this a sign that they have overloaded the server with too many databases?I appreciate some insight.Thanks,Dave |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-09 : 14:28:36
|
| Yes it is a sign that they have a lot of databases on their system, but I wouldn't say that it is overloaded. Your connection to them is probably pretty slow.But why are you using Enterprise Manager? Why not use Query Analyzer so that you don't have to bother with the list of databases? Query Analyzer is way more powerful of a tool.Tara |
 |
|
|
Dave123
Starting Member
3 Posts |
Posted - 2003-07-09 : 23:28:55
|
| Tara,Thanks for the tip. I didn't even know about Query Analyzer. I am playing with it now and absoutely love it!So much to learn...Thanks for taking the time,Dave |
|
|
|
|
|
|
Why Refresh List of Databases?