What can you tell me about the object “Deprecated Features”

The SQLServer:Deprecated Features object in SQL Server provides a counter (Usage) to monitor the features designated as deprecated. In each case the counter provides a usage count that lists the number of times the deprecated feature was encountered since SQL Server last started.

This is a very costly object because it generates a lot of data records that may not be needed to create performance reports. It is available on the Master Collection set of Performance Sentry Administration for inclusion in custom collection sets for the Performance Sentry Collection service but the SMF data files generated are very large in size. It is not recommended for use over a long period of time because of the large amount of data generated.

 For further information on the object, please click on the link below:

http://technet.microsoft.com/en-us/library/bb510662.aspx

Comments are closed.