SQL Server Performance

Load Distribution

Discussion in 'SQL Server Log Shipping' started by krajdba, Aug 16, 2005.

  1. krajdba New Member

    Hi Gurus

    There is a huge burden on our Database server.How can I distribute the load in SQL Server.
    Please also let me Know How can I store data files of a database in different server
    in order to reduce the I/O congession.

    Please let me know if you have any other solutions of distributing the load on server
    to a different server of the same database.


  2. satya Moderator

    What kind of burden is that the datbase server is facing?
    If you want to distribute the load then you can take help of load balancing from operating system.

    http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/hasog04.mspx,http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=8911&Key=Network Load Balancing (NLB) for information.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. FrankKalis Moderator

    SQL Server Clustering provides little to no help in load balancing. It purpose is to provide failover technology.

    What exact problems are you facing and what environment are we talking about? OLTP or OLAP?

    Frank Kalis
    Microsoft SQL Server MVP
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  4. krajdba New Member


    The problem that I am facing is Read congestion where as write seems to be ok.
    it is OLTP.there are about 20 plus users with about 40+ GB database.I have distributed the
    physical files of the database accorss three hard disks.

    But for the most of the time users use data from one particular disc, which is why this is
    causing REad congestion.

    Now If I wanted to store some datafiles to a different server disc, What should I do...?

    Please also give me links for the TWO WAY REplication.I am thinking one other solution is
    two way replication and distribute the users across the servers.


  5. satya Moderator

  6. FrankKalis Moderator

    Search on my site on "replication" (Use the textbox in the upper right corner next to the date for it). The result page contains 26 links. Almost all are links back to MS pages. That should be a good start.

    Frank Kalis
    Microsoft SQL Server MVP
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  7. rgagne99 New Member

    I'll throw a couple of ideas at you. If you posted this in the log shipping forum it sounds like you are considering whether maintaining a parallel copy of the DB could help reduce the read load on the production server.

    Also, wouldn't a RAID-5 spread the reading across many spindles and result in faster throughput for you?

    Just some thoughts, not recommendations.


Share This Page