SQL Server Performance Forum – Threads Archive
Clustering and/or Replication Examples
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 Sommerswww.shift4.com
May search under this linkhttp://itresearch.forbes.com/rlist/term/Clustering.html for information and previously I’ve used for one of the white paper information. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
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
Webmaster
SQL-Server-Performance.Com
Thanks to both of you. That helped.
]]>