Just Code‎ > ‎

TSQL - Find which deprecated features being used by querying sys.dm_os_performance_counters

posted Sep 9, 2013, 4:19 AM by Peter Henell   [ updated Sep 9, 2013, 4:20 AM ]
Find out which features being used in your server that are deprecated. Use Tracing or Extended events to figure out where these features are being used.
SELECT  instance_name ,
        cntr_value
FROM    sys.dm_os_performance_counters
WHERE   Object_name = 'SQLServer:Deprecated Features'
        AND cntr_value > 0
Comments