SQL Server 最佳实践
发布日期: 2007年6月13日
作者: Denny Lee, Nicholas Dritsas
投稿人: Lubor Kollar, Lindsey Allen
此白皮书描述了如何为Microsoft SQL Server 2005 Analysis Services 建立一个可伸缩且负载平衡的查询环境，以便处理在Analysis Services 服务器上并发的大量查询请求。负载平衡查询可以确保针对OLAP 多维数据集的读取在任何时刻都能查询到最新的聚合，并且将查询负载分散到所有可用的服务器上。这种scale-out 查询架构可以优化多维数据集的处理时间，增加多维数据集更新的频率，并让处理过程更加健壮，因为你可以提供更加频繁的处理能力以及透明化的错误恢复。
更多信息，请参考白皮书 Scale-Out Querying with Analysis Services
About denny.lee
Denny Lee is a Senior Program Manager based out of Redmond, WA in the SQLCAT Best Practices Team. He has more than 12 years experience as a developer and consultant implementing software solutions to complex OLTP and data warehousing problems. His industry experience includes accounting, human resources, automotive, retail, web analytics, telecommunications, and healthcare. He had helped create the first OLAP Services reporting application in production at Microsoft and is a co-author of “SQL Server 2000 Data Warehousing with Analysis Services” and “Transforming Healthcare through Information [Ed. Joan Ash] (2008)”. In addition to contributing to the SQLCAT Blog, SQL Server Best Practices, and SQLCAT.com, you can also review Denny's Space (http://denster.spaces.live.com). Denny specializes in developing solutions for Enterprise Data Warehousing, Analysis Services, and Data Mining; he also has focuses in the areas of Privacy and Healthcare.
|
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
|
|
