• quinn.jay (10/27/2016)


    All dev, Test and Prod is all on the same one instance.

    There's your problem. Remedy this and you won't have an issue. 😉

    There are a few ways in which you can see the usage of each cube and from that determine which cubes you can safely archive/migrate away from the instance.

    The first is a simple profiler trace. You'd have to leave it on for a few days probably and then output it to a table and analyse it. Not pretty but it'll get you there.

    You can turn on the Olap Query Log (https://technet.microsoft.com/en-us/library/cc917676.aspx) and let that run for a week or so and then query it to see what is being used.

    You can use extended events to capture any queries coming in to your cubes (https://blog.crossjoin.co.uk/2016/04/18/profiler-extended-events-and-analysis-services/) and then analyse the output of that after a week or so.

    These methods would involve communication to the users giving them a moratorium of the aforementioned time frames to use the cubes that they need or else they will be archived.

    Finally, if you have a list of SSAS users (through a security setting, for example) then you could simply ask them.

    Hope this helps 🙂


    I'm on LinkedIn