Forum Discussion
Facing OutOfMemory Exception when running a complex query in Fabric LH T-SQL Endpoint
Hi All,
I have a Fabric capacity that is running at F4 and I have 100+ views out of which, most of them execute without issues. There are 2-3 views that are complex and we had materialized the underlying tables as well to make sure it is performant, but when we try to run the view, it shows OutOfMemory Exception. I tried scaling the capacity to F32 as well but still got the same issue.
1. Query plan viewing is not supported. How can I know which part of my query is causing memory usage to be very high.
2. The capacity metrics app doesn't show spikes, which means most likely the query did not even start running. It failed before it could allocate memory for running.
3. The views we have, are being migrated from Azure SQL DB to Fabric, so we did not develop the views but migrate it as-is. The compute power of ASQL is S12 which is equivalent to F32 in cost terms. I usedf F32 to run but still got the same issue.
How to resolve this?
Metrics app output for a day when we tried to run the complex query multiple times.
3 Replies
Can you check the query plan in ASQL - maybe some runaway cartesians?
Hi govindarajan_d,
Can you please share some more detail information about this issue?(e.g. the function query use and sample formula) They should help us clarify your scenario and test to troubleshoot.
For monitor the t-sql status, you can take a look at following link:
Monitor your running and completed queries using Query activity - Microsoft Fabric | Microsoft Learn
Regards,
Xiaoxin Sheng
Hi govindarajan_d ,
Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
