SQL Server Performance Forum – Threads Archive
Clustering and/or Replication ExamplesCan 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
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
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
Thanks to both of you. That helped.