Capacity Specifications (Analysis Services- Data Mining)
The following table specifies the maximum sizes and numbers of data mining objects that you can define in Microsoft SQL Server Analysis Services. For maximum capacities of cubes and other related Analysis Services objects, see Maximum Capacity Specifications (Analysis Services - Multidimensional Data).
SQL Server Analysis Services Object |
Maximum sizes/numbers |
|---|---|
Databases in an instance |
2^31-1 = 2,147,483,647 |
Mining structures in an Analysis Services database or solution |
2^31-1 = 2,147,483,647 |
Models in a mining structure |
2^31-1 = 2,147,483,647 |
Attributes per mining structure |
2^31-1 = 2,147,483,647 |
Number of distinct states in a mining model attribute column |
2^31-1 = 2,147,483,647 |
Number of attributes considered (feature selection) |
2^31-1 = 2,147,483,647 |
In practice, the limits may be lower for optimal performance.