Analysis Services Operations Guide

The Microsoft SQL Server 2000 Analysis Services Operations Guide is available on the TechNet web site.

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx

Topics covered include the following.[ul]Introduction
Configuration Management
Release Management
Change Management
Security Administration
Service and Availability Management
Capacity Management
Problem and Incident Management [/ul]

The guide also contains several useful appendices.[ul]Appendix A: Checklist for Operations
Appendix B: Resources
Appendix C: How to Tune the Process Buffer Size
Appendix D: Sample Script for Changing the Data Folder Location
Appendix E: Sample Script for Creating Repository Audit Triggers
Appendix F: Sample Script for Creating an OLAP Linked Server
Appendix G: Sample Script To Verify Analysis Services Availability
Appendix H: Sample Script to Determine When Lazy Processing is Complete
Appendix I: Sample Script to Determine Whether Data Slices Have Been Set
Appendix J: Sample Script to Determine the Analysis Services Edition
Appendix K: Data Folder Structure
[/ul]