SQL Server 最佳实践
发布日期: 2007年8月
作者: Carl Rabeler, Eric Jacobsen
技术评论家: Craig Utley
提升单独MDX 的查询性能需要做很多事情。首先，你必须在性能不佳的MDX 查询中找到造成性能瓶颈的源。为了能够找到这个源，你需要理解如何使用现有的Microsoft Windows 以及SQL Server 2005 Analysis Services 的排错工具来辅助你找到瓶颈，并且你还要能够看懂这些工具所显示出的信息。这篇文章提供了现有工具的相关信息并演示了如何使用这些工具通过单独的MDX 查询来识别并解决MDX 查询性能瓶颈。 更多信息，请参考白皮书Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 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
|
|
