Forum Discussion
Query duration longer than 30mins limit/timeout
I stumbled upon this limitation in Synapse with serverless sql pool today there is a 30mins limit/timeout. Is there similar limitation in Synapse DataWarehouse?
Serverless SQL pool self-help - Azure Synapse Analytics | Microsoft Learn
- Anonymous2 years ago
Hi kkadap ,
In fabric, Synapse Data Warehouse does not have a 30-minute query duration limit.
If a query takes too long, you can optimize the query and use Dynamic Management Views (DMVs) to monitor query execution.
For more information on the performance of warehouse in Fabric, please refer to the official documentation below to learn more:
Warehouse performance guidelines - Microsoft Fabric | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot! Hi kkadap I've had SQL workloads running for nearly 2 hours on Fabric Warehouses with no issues. I can't find anything in the Fabric documentation that states any timeouts.
2 Replies
- AnonymousNot applicable
Hi kkadap ,
In fabric, Synapse Data Warehouse does not have a 30-minute query duration limit.
If a query takes too long, you can optimize the query and use Dynamic Management Views (DMVs) to monitor query execution.
For more information on the performance of warehouse in Fabric, please refer to the official documentation below to learn more:
Warehouse performance guidelines - Microsoft Fabric | Microsoft Learn
If you have any other questions please feel free to contact me.
Best Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!