Which DMV shows the status of a plan updated by automatic tuning?

The correct choice is the Dynamic Management View (DMV) that provides insights into tuning recommendations made by Azure SQL Database. This specific DMV, sys.dm_db_tuning_recommendations, is designed to show the status of performance tuning recommendations, including those that result from automatic tuning features. By querying this DMV, database administrators can access information about recommended changes, such as indexes that could improve query performance or statistics updates. This is particularly useful for monitoring and validating the impact of automated tuning operations on the database environment.

The other DMVs serve different purposes. For instance, sys.dm_exec_requests provides information about currently executing requests and their status, but it does not specifically pertain to automatic tuning recommendations. Similarly, sys.dm_exec_query_stats gives details about query execution statistics but does not encompass the automatic tuning updates. Lastly, sys.dm_exec_procedures focuses on information regarding the stored procedures within the database, which is also unrelated to auto-tuning recommendations. Thus, sys.dm_db_tuning_recommendations stands out as the most relevant DMV for monitoring the status of plans updated through automatic tuning.