Microsoft SQL Server Analysis Services Multidimensional Performance and Operations Guide.pdf

(6076 KB) Pobierz
1146657654.001.png
Microsoft SQL Server Analysis
Services Multidimensional
Performance and Operations Guide
Thomas Kejser and Denny Lee
Contributors and Technical Reviewers : Peter Adshead (UBS), T.K. Anand,
KaganArca, Andrew Calvett (UBS), Brad Daniels, John Desch, Marius
Dumitru, WillfriedFärber (Trivadis), Alberto Ferrari (SQLBI), Marcel Franke
(pmOne), Greg Galloway (Artis Consulting), Darren Gosbell (James &
Monroe), DaeSeong Han, Siva Harinath, Thomas Ivarsson (Sigma AB),
Alejandro Leguizamo (SolidQ), Alexei Khalyako, Edward Melomed,
AkshaiMirchandani, Sanjay Nayyar (IM Group), TomislavPiasevoli, Carl
Rabeler (SolidQ), Marco Russo (SQLBI), Ashvini Sharma, Didier Simon, John
Sirmon, Richard Tkachuk, Andrea Uggetti, Elizabeth Vitt, Mike Vovchik,
Christopher Webb (Crossjoin Consulting), SedatYogurtcuoglu, Anne Zorner
Summary : Download this book to learn about Analysis Services Multidimensional
performance tuning from an operational and development perspective. This book
consolidates the previously published SQL Server 2008 R2 Analysis Services Operations
Guide and SQL Server 2008 R2 Analysis Services Performance Guide into a single
publication that you can view on portable devices.
Category: Guide
Applies to : SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012
E-book publication date : May 2012
200 pages
1146657654.002.png
This page intentionally left blank
Copyright © 2012 by Microsoft Corporation
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means
without the written permission of the publisher.
Microsoft and the trademarks listed at
Microsoft group of companies. All other marks are property of their respective owners.
The example companies, organizations, products, domain names, email addresses, logos, people, places, and events
depicted herein are fictitious. No association with any real company, organization, product, domain name, email address,
logo, person, place, or event is intended or should be inferred.
This book expresses the author’s views and opinions. The information contained in this book is provided without any
express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will
be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.
Contents
2.1 
Design Patterns for Scalable Cubes ........................................................................................... 6 
2.2 
Testing Analysis Services Cubes .............................................................................................. 32 
2.3 
Tuning Query Performance ..................................................................................................... 39 
2.4 
Tuning Processing Performance .............................................................................................. 76 
2.5 
Special Considerations ............................................................................................................ 93 
3.1 
Configuring the Server ........................................................................................................... 106 
3.2 
Monitoring and Tuning the Server ........................................................................................ 133 
3.3 
Security and Auditing ............................................................................................................ 143 
3.4 
High Availability and Disaster Recovery ................................................................................ 147 
3.5 
Diagnosing and Optimizing .................................................................................................... 150 
3.6 
Server Maintenance .............................................................................................................. 189 
3.7 
Special Considerations .......................................................................................................... 192 
4 
 

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin