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
SQL Server 2005 memory configuration ... - SQL Server DBA
SQL Server database files configuration checklist - SQL Server
This is only a preview. Your comment has not yet been posted.
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.
Posted by: |