Query duration longer than 30mins limit/timeout

[kkadap]

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

[Anonymous · Accepted solution]

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 Team

If 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!

[AndyDDC · Accepted solution]

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.

[Anonymous · Accepted solution]

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 Team

If 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!