how to identify which cube is running or taking long time in azure analysis services?

Neha 101 Reputation points
2022-09-01T08:54:04.603+00:00

AAS server is full, we want to kill long running query therefore wants to understand if we have any direct way of getting long running query details

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
435 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 25,876 Reputation points Microsoft Employee
    2022-09-02T01:25:07.837+00:00

    Hi @Neha ,

    Welcome to the MS Q&A platform.

    You can use the below DMVs to Monitor the Long Running MDX Queries

    SELECT SESSION_SPID, SESSION_USER_NAME, SESSION_LAST_COMMAND,
    SESSION_LAST_COMMAND_ELAPSED_TIME_MS FROM $SYSTEM.DISCOVER_SESSIONS
    ORDER BY SESSION_LAST_COMMAND_ELAPSED_TIME_MS DESC

    Reference document: https://learn.microsoft.com/en-us/archive/blogs/johndesch/using-dmvs-to-monitor-and-terminate-long-running-mdx-queries

    Please let us know if you have any further questions.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators