Azure database first query slow

Laco 1 Reputation point
2021-04-19T10:44:31.193+00:00

This is database for testing without any backend connected to it!

Tested from SSMS

First Query after few hours of inactivity (Execution time is 3min)
89115-firstrun.png

Same Query second time (Execution time is 12 sec) !!!!
89095-secondrun.png

Same question I posted on stackoverflow...

https://stackoverflow.com/questions/67070819/azure-sql-timeouts-for-first-request-after-some-period

Do you have any advice other than going to a higher paid tier?

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. KalyanChanumolu-MSFT 8,251 Reputation points Microsoft Employee
    2021-04-26T06:38:57.987+00:00

    @Laco It seems like your SSMS session is getting disconnected after a period of inactivity.
    It needs to establish the connection first before executing the query resulting in longer overall duration.
    Also, I notice that Execution Plan is included with the results, turning it OFF will improve execution time

    ----------

    If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.

    No comments