I'd like to announce to the group that a whitepaper titled "Analysis Service
Performance Guide" has been posted to TechNet at

http://www.microsoft.com/technet/tre...e/ANSvcsPG.asp


Below is a list of the topics that are covered by the whitepaper.

Microsoft SQL Server 2000 Analysis Services Performance Guide
Authors: Carl Rabeler, Len Wyatt, Dave Wickert

Introduction
Optimizing Analysis Services to Improve Query Responsiveness
Optimizing Analysis Services to Improve Processing Performance
Optimizing the Data Model to Improve Performance
Optimizing Hardware Resources to Improve Performance
Optimizing the Architecture to Improve Performance
Optimizing Clients for Slow Network Connections
Summary
Appendix A: Resources
Appendix B: Interpreting Performance Monitor Counters
Appendix C: How to Flush the Query Results Cache
Appendix D: How to Tune the Process Buffer Size
Appendix E: A Checklist of Configuration Steps for an Analysis Server
Appendix F: When to Consider Moving to SQL Server 2000 (64-bit)


--
Sean Boon
SQL Server BI Product Unit

**This posting is provided AS IS, with no warranties, and confers no
rights.**

In my opinion, this is the best whitepaper available for Analysis Services -
I learned a lot from reading it, and I think Carl, Len and Dave have done a
great job. I would recommend everyone to download it asap!

--

Chris Webb
Consultant, Microsoft Services Switzerland
(to email: remove 'online.' from the address this was posted with)

Microsoft Services Switzerland and our partners can help you with your
Analysis Services project!

Disclaimer: This posting is provided 'AS IS' with no warranties, and confers
no rights.

"Sean Boon [MS]" <seanboon (AT) online (DOT) microsoft.com> wrote