Forum Discussion
Fabric SQL - killing my enviroment
Hi
I just sat op a fabric sql - and tried adding some datasets, and so far it works like a charm.
But suddenly it peaks and blocks my entire enviroment - without me having access to the sql, so stop it?
What do I do?
Hi Fragmaticx ,
Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue you are encountering.
Upon reviewing the sceenshots, below suggestions might help you in resolving the issue.- The query may be processing a very large dataset, causing the system to exceed memory or computational limits. Consider breaking down the query into smaller batches and process them.
- Check if environment may have allocated with enough memory to handle the workload
- If you are able to identify and isolate long-running queries causing deadlocks either wait for them to complete or terminate them if you have sufficient privileges.
Providing the documents for your reference:
Billing and Utilizing
Performance DashboardIf this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
4 Replies
Hi Fragmaticx ,
Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue you are encountering.
Upon reviewing the sceenshots, below suggestions might help you in resolving the issue.- The query may be processing a very large dataset, causing the system to exceed memory or computational limits. Consider breaking down the query into smaller batches and process them.
- Check if environment may have allocated with enough memory to handle the workload
- If you are able to identify and isolate long-running queries causing deadlocks either wait for them to complete or terminate them if you have sufficient privileges.
Providing the documents for your reference:
Billing and Utilizing
Performance DashboardIf this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Hi Fragmaticx ,
We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
If our response addressed your query, please mark it as Accept Answer and click Yes if you found it helpful.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!Hi Fragmaticx ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you for your cooperation. Have a great day.Hi Fragmaticx ,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.
If it is solved, please accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you for being a part of the Microsoft Fabric Community Forum!