SQL Server Deprecated Feature Usage

[goldenjacob]

This is a good article on deprecated feature usage and how to capture metrics around it, etc. Wondering if it would make sense to capture this as a counter metric as well as the code being used?

https://www.sqltabletalk.com/?p=1210

Talks about using something like this to capture the instances of usage, and then provides a build of an extended event that captures the deprecated events that could maybe be built into the existing extended event?

Query:
SELECT object_name,
instance_name AS DeprecatedFeature,
cntr_value AS UseCount
FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%Deprecated Features%'
ORDER BY cntr_value DESC;

X Event:
CREATE EVENT SESSION Demo_Deprecated_Features
ON SERVER
ADD EVENT sqlserver.deprecation_announcement

[DavidWiseman]

Hi, this isn't something I'm interested in implementing in DBA Dash. You could track the performance counters in DBA Dash already but there are a lot of them and it will increase the size of the associated tables in the repository DB as the counters track every 1min. A custom collection might work better. Or just keep it outside DBA Dash, using the perf counters to get a summary and an XE if you need to capture more detail. I'm not sure if there is significant value in continuous monitoring for this.