SQL Server Retreive Databases
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=18555
Printed Date: 29 March 2026 at 10:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: SQL Server Retreive Databases
Posted By: Gullanian
Subject: SQL Server Retreive Databases
Date Posted: 01 March 2006 at 10:23pm
|
Anyone know how to speed up when you double click on getting the database list from a server? When I connect to gearhost through Enterprise Manager, it takes about 5 seconds to connect to the server, then about 20 mins to get the database list up. |
Replies:
Posted By: dpyers
Date Posted: 02 March 2006 at 12:23am
|
EM is slow but 20 minutes is excessive. There was an update a few months back that speeds up EM considerably. I think it was an update to SQL Server, but it might have been to EM also. ------------- 
Lead me not into temptation... I know the short cut, follow me. |
Posted By: michael
Date Posted: 02 March 2006 at 4:56pm
|
Install the SQL 2005 management tools, they are much faster... ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |
Posted By: wistex
Date Posted: 20 April 2006 at 4:47am
|
It also could be that the database server you are on is overloaded. I've been on a number of servers, and the amount of load on the server does effect how long it takes for you to connect. ------------- http://www.wistex.com" rel="nofollow - WisTex Solutions http://www.caribbeanchoice.com/forums" rel="nofollow - CaribbeanChoice Forums |