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.

Community Additions

ADD
Show: