.png)
Maximum Capacity Specifications (Analysis Services)
The following tables specify the maximum sizes and numbers of various objects defined in Analysis Services components under different server deployment modes.
This topic contains the following sections:
MOLAP storage mode, which stores both data and metadata, has additional physical limits on file sizes. String store files are a maximum size of 4 GB by default. If you require larger files for string stores, you can specify a different string storage architecture. For more information, see Configure String Storage for Dimensions and Partitions.
|
Object |
Maximum sizes/numbers |
|---|---|
|
Databases in an instance |
2^31-1 = 2,147,483,647 |
|
Dimensions in a database |
2^31-1 = 2,147,483,647 |
|
Attributes in a dimension |
2^31-1 = 2,147,483,647 |
|
Members in a dimension attribute |
2^31-1 = 2,147,483,647 |
|
User-defined hierarchies in a dimension |
2^31-1 = 2,147,483,647 |
|
Levels in a user-defined hierarchy |
2^31-1 = 2,147,483,647 |
|
Cubes in a database |
2^31-1 = 2,147,483,647 |
|
Measure groups in a cube |
2^31-1 = 2,147,483,647 |
|
Measures in a measure group |
2^31-1 = 2,147,483,647 |
|
Calculations in a cube |
2^31-1 = 2,147,483,647 |
|
KPIs in a cube |
2^31-1 = 2,147,483,647 |
|
Actions in a cube |
2^31-1 = 2,147,483,647 |
|
Partitions in a cube |
2^31-1 = 2,147,483,647 |
|
Translations in a cube |
2^31-1 = 2,147,483,647 |
|
Aggregations in a partition |
2^31-1 = 2,147,483,647 |
|
Cells returned by a query |
2^31-1 = 2,147,483,647 |
|
Record size of the source query |
64K |
|
Length of object names |
100 characters |
|
Maximum number of distinct states in a data mining model attribute column |
2^31-1 = 2,147,483,647 |
|
Maximum number of attributes considered (feature selection) |
2^31-1 = 2,147,483,647 |
For more information about object naming guidelines, see ASSL Objects and Object Characteristics.
For more information about data source limitations for online analytical processing (OLAP) and data mining, see Supported Data Sources (SSAS - Multidimensional Models), Supported Data Sources (SSAS - Multidimensional Models), and ASSL Objects and Object Characteristics.
|
Object |
Maximum sizes/numbers |
||
|---|---|---|---|
|
Databases in an instance |
2^31-1 = 2,147,483,647 |
||
|
Tables in a database |
2^31-1 = 2,147,483,647 |
||
|
Columns in a table |
2^31-1 = 2,147,483,647
|
||
|
Rows in a table |
Unlimited
|
||
|
Hierarchies in a table |
2^31-1 = 2,147,483,647 |
||
|
Levels in a hierarchy |
2^31-1 = 2,147,483,647 |
||
|
Relationships |
2^31-1 = 2,147,483,647 |
||
|
Key Columns in a table |
2^31-1 = 2,147,483,647 |
||
|
Measures in a table |
2^31-1 = 2,147,483,647
|
||
|
Calculated Columns in a table |
2^31-1 = 2,147,483,647
|
||
|
Cells returned by a query |
2^31-1 = 2,147,483,647 |
||
|
Record size of the source query |
64K |
||
|
Length of object names |
100 characters |
Caution
|
Object |
Maximum sizes/numbers |
||
|---|---|---|---|
|
Databases in an instance |
2^31-1 = 2,147,483,647 |
||
|
Tables in a database |
2^31-1 = 2,147,483,647 |
||
|
Columns in a table |
2^31-1 = 2,147,483,647
|
||
|
Rows in a table |
Unlimited
|
||
|
Hierarchies in a table |
2^31-1 = 2,147,483,647 |
||
|
Levels in a hierarchy |
2^31-1 = 2,147,483,647 |
||
|
Relationships |
2^31-1 = 2,147,483,647 |
||
|
Key Columns in a table |
2^31-1 = 2,147,483,647 |
||
|
Measures in a table |
2^31-1 = 2,147,483,647
|
||
|
Calculated Columns in a table |
2^31-1 = 2,147,483,647
|
||
|
Cells returned by a query |
2^31-1 = 2,147,483,647 |
||
|
Record size of the source query |
64K |
||
|
Length of object names |
100 characters |
