I have a SQL Managed Instance (General Purpose Gen5 (256 GB, 4 vCores). I want to know if this database has a "Cold Start" delay on the first query after some idle time. If so, How can this be prevented. It sometimes takes over 1 1/2 minutes to return the first query after some period of inactivity. After that first query request comes back in seconds.
In my setup I have an AppServce API making calls to the SQL Managed Instance. We need to find a way to keep the database alive and responsive at all times. Is this possible. If so how would I do it?