we are using SQL Server 2016 and currently we are facing some performance issues. Solarwinds tells us, that there is sometimes much wait time caused by a Lock "LCK_M_SCH_M".
I was now able to check the activity monitor while we have there problems and I saw that our server dropped an index with the user "Database Engine Tuning Advisor" and that this causes the named lock.
Can someone tell me why the server is doing this and how I can stop it? As I read this is a feature from Azure SQL Database 2017 and not SQL Server 2016.