Post reply

Reduce SQL Server Loda

  • August 25, 2011 at 5:05 am

    #246796

    I have got a high load and busy SQL server 2008 R2 with 3000 online users, How can I distribute server load by using 2 or more servers ?

    May I use Clustering solution in order to reduce server load ?

  • August 25, 2011 at 5:27 am

    #1373042

    Clustering is High Availability, not scale-out.

    Scale-out in SQL is difficult, there's no automatic way of doing it. You may find it easier to tune the database and scale up.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 26, 2011 at 9:51 am

    #1373901

    can you be specific about what part of the "load" is actually giving issues. Normally there is a visible indication of a bottleneck.

    Depending upon your database structure it would be theoretically possible to use peer to peer replication to spread load, although this is more useful for intensive reads.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply