SQL Server Performance
  1. eliemehawej New Member

    I have a small problem and I hope you can help me.

    I have a wireless link between 2 remote locations and in each location I have an SQL 2000 server. When sending queries between these 2 servers I am not able to use all the allocated bandwidth thus having a big delay between the 2 locations.



    Can you please advise what to do in order to increase the performance and be able to use all the bandwidth allocated.
  2. cmdr_skywalker New Member

    How can you tell if you're not using the allocated bandwidth?

    May the Almighty God bless us all!
    www.empoweredinformation.com
  3. eliemehawej New Member

    I have a software PRTG that can tell me how much bandwidth i am using.

    thank you for replying me.
  4. satya Moderator

    Capture the resource usage using PERFMON & PROFILER for slow running queries and if it is bandwidth problem check with Network admin to see any contention on the network.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page