Complete a Server Assessment – Auto Tuning Settings

Below you will find the code for the Auto Tuning Settings of a database.  Simply select the text and copy to the Clipboard.

Return to Code Library Main Page

SELECT DB_Name() AS ‘DBName’
, Name AS ‘OptionName’
, Desired_State_Desc ASDesiredStateDesc’
, actual_State_Desc AS ‘ActualStateDesc’
, Reason_Desc AS ‘ReasonDesc’
FROM sys.database_automatic_tuning_options

This code was written using the Microsoft SQL Server documentation.  If you find that this code was copied from else where, please let me know so I can give proper credit.