How Long to Load

Discussion in 'Database Support' started by Harrison, Aug 13, 2004.

  1. Harrison

    Harrison Perch

  2. devorem

    devorem Perch

    It takes me quite a while to load, too. But not 10 to 15 minutes. It takes maybe 20-25 seconds or something mildly annoying like that. That time-test is over a DS3 line, but I looked at my bandwidth usage during that time and it was very small. I would think that it would take about the same amount of time for a dial-up user, but I don't really know. I have DSL at home and it is about the same as here at work with the DS3.
  3. Harrison

    Harrison Perch

  4. DirtBag

    DirtBag Perch

    I have dial-up too and it takes 10-15 minutes here to.. this is because of the large amounts of data Enterprise Manager downloads..

    weird MS hasn't made it so that only databases where the logged in user has access is downloaded..
  5. SubSpace

    SubSpace Bass

    The load time is mostly dependant on latency (ping time) to the database server, not bandwidth.
    For some reason the Enterprise Manager basically requests all the database information 1 database at a time instead of in bulk.
    On a LAN this isn't so much of a problem, but on long distance connections it can have disastrous results like this.

    From the times I have observed it's actually even worse and the program seems to make multiple roundtrips to get all information on a database.

    Let's assume you have a 300ms ping time because you're in Australia, and that every database causes 3 requests for information from the Manager client. Now there's also 300'ish databases on the server, so the minimal theoretical time it would take to load the entire list (assuming infinite bandwidth and program response speeds) would be: 300*3*300 = 270,000ms = 4,5 minutes.
    I don't have any actual numbers, but as you can see this can quickly amount to long response times, while the same data exchange could theoretically be done within a second on a broadband line if only it was done in bulk.

    Basically the Enterprise Manager is not designed to work over an internet connection. Loading only the databases one actually has access to would be very helpful without requiring a large rewrite of any of the software, but it's not gonna happen :(

    SQL Server 2005 is in beta at the moment, perhaps that will improve things eventually. From the feature list I understand the management tools have been changed rather extensively.
  6. Harrison

    Harrison Perch

    just wanted to add my response times have improved dramatically. Now it is only a few seconds before I connect. :)
  7. Its all the dang DB's that load. Once it has them reconnecting is quick. Query Analizer only connects to the DB you have permission to though.
  8. Darren

    Darren Guppy

    Say where did you get Enterprise Manager and how much was it?
  9. Harrison

    Harrison Perch

  10. Harrison

    Harrison Perch

  11. megan

    megan Perch

  12. Dave

    Dave Perch

    Thanks for this link, Megan. The update increased my Enterprise Manager access time from something over 5 minutes to 30 to 40 seconds!
  13. megan

    megan Perch

    You're quite welcome ;) ~megan
  14. Harrison

    Harrison Perch

    would anyone please care to check if access to their database is available through enterprise manager. My client seems to show no items available in the database console tree.

    nm seems to working now :)

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services