SQL Server Performance Forum – Threads Archive

Maximum number of cubes

Is there / what is the maximum number of cubes you can create in Analysis Services?

I think it is 255 maximum. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Hi Satya U r again correct as always…
seanpk refer to this link:
specifications and limits—-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agref_4vlf.asp

At the Analysis Services 2000 MOC, they teached me there is no limit to the number of Cubes per database (unlimited), but only to the cubes per virtual cube (64).

If I’m not wrong, the page in the link refers to the number of cubes in a virtual cube (in the MOC course book 64, in the link 255, strangely), not to the cubes in a database, which should be potentially unlimited.

You must have some budget on your server hardware [<img src=’/community/emoticons/emotion-2.gif’ alt=’

‘ />] Raulie hp

Thanks for the clarification Vania, which is unusual to have such number of cubes more than 255. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>