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

Post date: Sep 9, 2013 11:19:57 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