Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Capacity Specifications (Analysis Services- Data Mining)

SQL Server 2008 R2

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft