CODEWITHSUNDEEP
sql-serversql-server-2008-r2ssas
Raj More
Raj More

Reputation: 48024

How can I find the actual size of SSAS Partition?

The properties window for a partition only shows the estimated size of the partition.

enter image description here

Is there a way to get the actual size of a partition?

Edit:

I do not have administrative or remote desktop permissions to the server. While SSAS permissions can be granted, remoting in is not a possibility for me.

Upvotes: 1

Views: 2704

Answers (1)

Bill Anton
Bill Anton

Reputation: 2970

The easiest way I can think of would be to check the files on disk. The data for each partition is broken out into it's own folder. 

..\<Cube>\<MeasureGroup>\<Partition1>
..\<Cube>\<MeasureGroup>\<Partition2>
..
..\<Cube>\<MeasureGroup>\<PartitionN>

enter image description here

You'll probably want to script it using PowerShell if you need to gather this info regularly for more than a few partitions. Also, keep in mind that the partition-level folders include data for aggregations as well (which you may or may not want).

Upvotes: 4

Related Questions