SQL Server Performance

Clustering and/or Replication Examples

Discussion in 'SQL Server Clustering' started by Shift4SMS, Jul 13, 2004.

  1. Shift4SMS New Member

    Can anyone give me some examples of companies using MSSQL 2000 replication and/or clustering with high transaction volumes? I've only been able to find two case studies published by Microsoft, one for Countrywide and one for Wildcard Systems. Countrywide I've heard of, Wildcard I have not and neither case study gives me a hint of transactions per hour or day being synchronized.

    Basically, I'm fighting a battle with some of my coworkers to use MS's built in replication and clustering services or write our own because MS's advanced services have yet to be proven in high-volume (50,000+ updates per hour) real-time sites in the eyes of some of my coworkers.

    Any info would be GREATLY appreciated!!!

    Steve Sommers
  2. satya Moderator

  3. bradmcgehee New Member

    Clustering can work well with high volumes, on the other hand, replication with high volumes can be troublesome.

    Microsoft has a special department devoted to tuning SQL Server under high volume. They allow clients to bring in their application to their test labs for testing and performance tuning. I don't have their URL handy, but you can probably Google it.

    Brad M. McGehee, MVP
  4. Shift4SMS New Member

    Thanks to both of you. That helped.

Share This Page