Home / server / Questions / 134534
In Process
efk
Asked: 2010-04-22 09:33:38 +0800 CST

I need Microsoft SQL Clustering/Replication/Scaling Best Practice Resources

  • 772

I'm trying to plan for our future scalability of our Microsoft SQL 2000/2005/2008 infrastructure. I'm having a hard time finding good information on how to best engineer such services, how to best keep these services available, and how to scale them as load increases. Can someone point me in the right direction? Books, online resources, videos, anything would be helpful.

sql-server scaling

3 Answers

  1. The folks at SQL Skills (Kimberly Tripp, Paul Randal, Bob Beauchemin, Stacia Misner) keep a relatively current list of all available Microsoft SQL Server whitepapers. You can find the list here:

    http://www.sqlskills.com/whitepapers.asp

    You'll probably want to check out the High Availability with SQL Server 2008 whitepaper listed there (authored by Paul).

    • 2

  2. microsoft.com/sql

    look for the white papers they have all the scaling\infrastructure stuff documented.

    • 1

  3. Beside the good pointers you already received, I suggest also the SQL Server Customer Advisory Tam site. They have plenty of studies and practical information from the field.

    http://sqlcat.com

    • 0