SQL 2008 Deprecated Features

This is a quick tip to show you how to list the SQL Server 2008 deprecated features and how to tell if they are still being used in any of your databases.

A deprecated feature is one that will not be supported in a future version of SQL Server.

These old features can still be used, but you need to start modifying code now to ease the transition when you upgrade.

The list of deprecated features can be viewed in Books Online, where they are divided into those due to be removed in the next version, and those that will removed after that.

Microsoft have added a Performance Counter object to enable use of these features to be tracked, but using perfmon is not the most convenient way of doing it. Luckily, you can query a DMV:

select instance_name, cntr_value from sys.dm_os_performance_counters where [object_name] like ‘%Deprecated%’ and cntr_value > 0

This will return all SQL Server 2008 deprecated features that have been used since the last service restart, together the number of occurrences.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s