Forum Discussion

kkadap's avatar
kkadap
Regular Visitor
2 years ago
Solved

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

 

 

  • Anonymous's avatar
    Anonymous
    2 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 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!

  • 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

  • AndyDDC's avatar
    AndyDDC
    Most Valuable Professional

    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's avatar
    Anonymous
    Not 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 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!