September 19, 2011 at 9:19 pm
In our backend we have to host 4 cube databases each housing 1 cube. Sizes of the 4 database are 10gb, 10gb, 10gb and 50gb. At any given time we can have 3 cubes getting processed. Is there any limitation on analysis services instance on the number / size/ parallel processing?
Thanks
September 20, 2011 at 1:08 am
It is not very clear, if you have currently a performance problem or not, so I'll provide a generic answer.
Some maximum capacity numbers for SQL Server Analysis Services, see here .
As you will see there are not many restrictions.
If your cubes start having the size of 50 GB it can be a good idea to implement cube partitioniong, but it depends on the datamodel and the data distribution, the configuration of the server and the load on the server.
Further, you can have a look if there are any large dimensions that are shared between te cubes : maybe these can be processed at forehand and the cube measuregroups separately.
Further, has SSAS enough resources, is it properly configured and is the host shared with other server applications ?
Moving a cube that is taking most processing resources to another host, can also be an option.
Regards,
Franky
Franky L.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply