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

Read More

SQL Server 2005 memory configuration ... - SQL Server DBA

SQL Server database files configuration checklist - SQL Server