Azure database first query slow

Question

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)

Same Query second time (Execution time is 12 sec) !!!!

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?

Answer 1

@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.