Post reply

check if cubes are used or not

  • June 29, 2016 at 1:34 pm

    #327495

    We have old SQL 2008 server which only has SSAS installed.

    I can login and see the cubes data sources are connecting one of our production servers.

    But developers in their group does not know who is using this SAAS server, or cubes?

    And they said no one using that as a report source either.

    How can I find out if there are active connections and who are using these cubes or not?

    Thanks

  • June 29, 2016 at 2:02 pm

    #1887715

    The query below should show you connections to the SSAS server. Not this is a DMX query not T-SQL.

    SELECT * FROM $system.discover_connect

  • June 29, 2016 at 2:18 pm

    #1887724

    Yes, I tried that, currently I can only myself is connecting to the server.

    Any other ways to check if the server has been accessed or cubes are being used in past month.

    We would upgrade the servers, but not sure if this server is used or not, probably not, but we want to make sure.

    Thanks

  • June 29, 2016 at 2:34 pm

    #1887730

    I imagine you would have to set up a profiler trace to monitor if anyone is accessing the cube. I'm not sure about any other logging build into SSAS but someone else might know.

    Is the cube still being processed? You could use the query below to check. If it hasn't been processed in a while then you could always stop the service and wait and see if anyone shouts

    SELECT CUBE_NAME, LAST_SCHEMA_UPDATE, LAST_DATA_UPDATE FROM $system.mdschema_cubes

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply