Fabric SQL database - slow queries

[JamesMurkin1]

Hi,

I am having trouble when using a SQL database in Fabric - it is taking a very long time to complete queries.

For example, when selecting all rows (<10) from a table with less than 10 columns, it is taking 40 seconds to complete:

I can see that the query execution time itself is very quick, but there seems to be a 20 second buffer before and after the query is completed.

A similar thing happens when perform other operations, such as creating/altering a stored procedure, inserting/deleting records - always around 40 seconds to complete.

For reference, I am currently operating on an F2 capacity. I sometimes find that when I first complete such a query on a given day, it will run quickly, but any subsequent queries are very slow (as above).

Is this a capacity issue, or perhaps expected behaviour?

Thanks 🙂

[idrismotiwala · Accepted solution]

Hi @JamesMurkin1 , sorry to hear about the slow experience. Could you please create a support ticket and provide your Fabric Tenant, Workspace and Database ID information in the supporte request for our support team to look at the telemetry to help troubleshoot. It could be an F2 capacity as it might be throttling but 10 rows returning for 10 cols in 40s is not normal and not expected behavior. Appreciate your patience and support.

[JamesMurkin1]

Hi @idrismotiwala.

Thanks for the suggestion - I have raised a support ticket accordingly. I will respond to this thread with any response/solution that is provided.

Thanks 🙂

[v-echaithra]

Hi @JamesMurkin1 ,

As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue through support or if you need further help.

If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.