How to Measure DAX Query Memory

[tctrout]

Hello Community,

I would like to know how to measure the total Memory used by a DAX Query?  

I am leveraging DAX Studio, PowerBI Performance Analyzer and have isolated the DAX Query that I want to investigate.  I want to measure the total Memory to see if it is approaching the Premium workload default memory limit of 6 GB.  
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-premium-workloads#query-memory-limit

I can run the PBIX locally and monitor the memory within my PC's Task Manager and see I am exceeding 6 GB.  However, I would think there is a better way to measure this within DAX Studio but I am unable to find it within Server Timings.  Is it listed somewhere else?  I see there is a KB column in the Server Timings, do I simply sum this for total KB used in the DAX Query?

[v-chenwuz-msft · Accepted solution]

Hi @tctrout ,

You are right, it is the estimated size in memory (measured in KB) of the result of the storage engine query (this result is also called data cache). 

https://www.sqlbi.com/blog/marco/2016/11/01/new-server-timings-features-in-dax-studio-2-5-0-dax-powe... 

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.