You have a Microsoft Azure SQL database. You discover that the workload grows over time. You are evaluating whether to switch to a higher service tier for the database. You need to examine the…

sys.dm_exec_query_stats provides aggregate performance statistics for cached query plans, which is useful for individual query tuning, but not for overall system utilization trends over time.

sys.events is not a standard DMV for resource utilization and typically refers to event handling in programming, not SQL Server performance monitoring.

The sys.resource_stats view in Azure SQL Database provides CPU, data I/O, log I/O, and memory consumption data for the database, recorded every 5 minutes and retained for 14 days. This historical data is crucial for analyzing resource utilization trends to determine if a higher service tier is needed due to workload growth.

sys.dm_db_missing_index_details provides information about missing indexes that could improve query performance, which is a tuning recommendation, not a view for historical system utilization trends.