Azure database first query slow

Laco 1 Reputation point

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

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

    @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