Hi,
We started noticing consistent high App CPU Billing on one of our development Azure SQL Databases and used Azure Data Studio - Profiler to identify two SSMS instances that would connect to the database approximately every 7 min. See attached screen shot. The two SSMS instances in question were left up running overnight, but no querying was taking place, only the "SQL Server Management Studio" application was identified with login and logout events. I killed the processes on the database, but SSMS would reconnect within the 7 minute window.
We have 3 other people using SSMS (same version 18.11.1) who do not show the same activity - usually only a single login/logout for the extended periods with the SSMS client open.
As a workaround we have people explicitly disconnect their Azure SQL Databases at the end of the day, but this is not a sustainable solution.
Screen shot of profiler:
Has anyone experienced this before? Or have any ideas what might be causing the repeated connection from the SSMS client?
Thank you.
Cheers,
Andy
