identify unused aggregations
SQL server has a dynamic management view called sys.dmdbindexusagestats which can tell you whether each index is being used.
SSAS should have the same type management view for its aggs and indexes and attributes... if you've had a cube in production for a few months and a handful of aggs haven't ever been used, they should be removed... this would be an easy way to tell. This is sort of the flip side of Query Based Optimization.
0
votes
AdminMicrosoft SQL Server
(Product Manager, Microsoft Azure)
shared this idea
Upvotes: 1
<=-=Oct 15 2007 12:34PM=-=>There’s a feature in BIDS Helper that will help until something gets added to SSAS itself:
<=-=Apr 28 2008 4:53PM=-=>Dear furmangg,
Unfortunately, this feature will not be added for SQL Server 2008, but we are considering for the next major release.
Thanks again for recommending this.
The Analysis Services Team