Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at HASSUG.
Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes
As a followup to a question from the presentation about clustering the appliances, I have found that Dell offers a high availability solution that clusters two Fast Track servers and two SAS arrays in an active/passive configuration (view details). It’s likely most of the other vendors who support Fast Track have clustering options. For the Database Consolidation Appliance (DBC), you can implement a multi-site disaster recovery plan if you have a multi-rack DBC Appliance. The different racks that make up the DBC Appliance can be implemented at different locations and configured as a multi-site cluster for disaster recovery purposes.
Scaling SQL Server to HUNDREDS of Terabytes
Learn how SQL Server 2008 can scale to HUNDREDS of terabytes for BI solutions. This session will focus on Fast Track Solutions and Appliances, Reference Architectures, and Parallel Data Warehousing (PDW). Included will be performance numbers and lessons learned on the very first PDW implementation in the world and how a successful BI solution was built on top of it using SSAS.
Learn about all the different appliances and how they can save you a tremendous amount of time and money instead of building on your own: HP Business Decision Appliance (BDA), HP Business Data Warehouse appliance (BDW), HP Enterprise Data Warehouse Appliance, and HP Database Consolidation Appliance.
If you are involved in the decision making in your company for purchasing one or more servers to be used for SQL Server, this session will make you aware there are options outside of the usual ordering a server and internally installing the hardware, OS, and SQL Server.