Published: February 2009
Writers: Stuart Frost, Dave Salch, Paul ***, Karl Schendel, Mark Theissen, Jesse Fountain, Stuart Ozer, Sonya Marshall, John Hoang, Murshed Zaman, Rick Brown, Glenn Yoshimura, Allan Haywood, Dave Christensen, Scotty Moran
The purpose of this document is to define a repeatable architectural approach for implementing a scalable model for an symmetric multiprocessor (SMP)-based Microsoft SQL Server 2008 data warehouse. The end result of this process represents the recommended minimal SQL Server configuration, inclusive of all the software and hardware, required to achieve and maintain a baseline level of “out of box” scalable performance when deploying SQL Server data warehousing (SSDW) sequential data access workload scenarios versus traditional random I/O methods.
The target audience for this document consists of IT planners, architects, DBAs, CIOs, CTOs, and business intelligence (BI) users with an interest in options for their BI applications and in the factors that affect those options.
For more information, please refer to the Implementing a SQL Server Fast Track Data Warehouse whitepaper.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
|
