Question: Is there a DMV displaying the deprecated features of a SQL Server Instance?
I’ve read the post Perfmon SQL Server Deprecated Features Object, which reports on deprecated features usage, but I’d prefer the output from a SQL statement/
Answer: The sys.dm_os_performance_counters DMV supplies the information from the Deprecated Features counter. This query supplies all the deprecated features with a usage count for a name instance.
Replace MSSQL$EXAMPLE with a your named instance. If you want to check on a default instance use SQLServer.
SELECT object_name, instance_name, cntr_value FROM sys.dm_os_performance_counters WHERE object_name = 'MSSQL$EXAMPLE:Deprecated Features'
When I upgrade a SQL Server – I’ll let the SQL Server run for a few days . Then I’ll create a report and work with the owner to address any potential issues