Tracking the Use of Deprecated SQL Server Features

Hi Marcos,

Below is Itzik Ben-Gan's response to your question:

“Perhaps you’re already aware of it, but just in case you aren’t, this small sidebar is just a side note in a main article about Deprecated T-SQL Features. You can find the main article here: http://www.sqlmag.com/articles/articleid/100697/Deprecated_TSQL_Features.html.
As for your question, this sidebar simply mentions that SQL Server provides tools that can help you track the use of deprecated features both through Performance Monitor counters, and SQL Server Trace events. If you’re not familiar with those tools, I suggest simply trying. Open performance monitor (perfmon.exe), and choose the counters I mentioned in the article (SQLServer:Deprecated Features object, Usage counter, and then specific instances of deprecated features). Then, whenever the deprecated feature that you track with the counter is used, the counter will indicate it.
Similarly, to use the trace events to track use of deprecated features, open SQL Server Profiler, and define a trace with the events mentioned in the article (under the Deprecation category, the Deprecation Final Support and Deprecation Announcement events). You will get a trace event whenever a deprecated feature is used.

Cheers,

Itzik”


Thanks for reading our articles, and feel free to contact me if you have any more questions.


Megan Keller

Associate Editor, SQL Server Magazine

mkeller@sqlmag.com

Could you explain a little bit more?