Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Unanswered: DB Connection Speed

    This may be more appropriate on another forum, but wanted to see if anyone could give me any ideas.

    We have SQL 7 on NT4. We are restricted from upgrading for a couple of particular reasons, but things nevertheless run fairly stable.

    We have roughly 100 - 140 simultaneous connections.

    Some users have very slow access times where others have a fast connection time. This is not restricted to DB access, but also for file transferring.

    Just like you can test your DSL/Cable speeds, are there any similar tests that can be ran on client machines to find their access speeds to the SQL database server?

    I really appreciate your suggestions!

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Ensure those slow connection clients does have similar MDAC/hotfixes installed that are on server and other client machines.

    And its good idea to check from network point of view and reduce the bottleneck at the base level.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •