Find SQL deprecated features with sys.dm_os_performance_counters

15 July,2014 by Jack Vamvas

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


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Find SQL deprecated features with sys.dm_os_performance_counters


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer