SQL Server 2005 Analysis Services (SSAS) Server Properties

Table of content

Executive Summary
About This Paper
Introduction
How This Document Is Organized
Server Properties
Conclusion

Executive Summary

SQL Server 2005 Analysis Services (SSAS) enables you to fine tune and control the behavior of SSAS. It does this through the use of properties that are available for configuration at the “instance-level.” These properties are known as server properties.

The behaviors that are controlled by server properties affect how SSAS processes partitions, cubes, and dimensions. They also affect performance, security, and the resources required by SSAS.

This whitepaper discusses the server properties that can be changed by a database administrator or system administrator and are listed in alphabetical order. It also gives some high-level information about the way SSAS manages memory, process memory, instances, languages, and thread pools.

Read more...