SELECT
MAX(end_time) AS 'Resource Usag Time',
MIN(avg_cpu_percent) AS 'Minimum CPU Utilization (%)',
MAX(avg_cpu_percent) AS 'Maximum CPU Utilization (%)',
AVG(avg_cpu_percent) AS 'Average CPU Utilization (%)',
MIN(avg_memory_usage_percent) AS 'Minimum Memory Usage (%)',
MAX(avg_memory_usage_percent) AS 'Maximum Memory Usage (%)',
AVG(avg_memory_usage_percent) AS 'Average Memory Usage (%)',
MIN(avg_data_io_percent) AS 'Minimum Data IO (%)',
MAX(avg_data_io_percent) AS 'Maximum Data IO (%)',
AVG(avg_data_io_percent) AS 'Average Data IO (%)',
MIN(avg_log_write_percent) AS 'Minimum Log Write I/O Throughput Utilization (%)',
MAX(avg_log_write_percent) AS 'Maximum Log Write I/O Throughput Utilization (%)',
AVG(avg_log_write_percent) AS 'Average Log Write I/O Throughput Utilization (%)'
FROM sys.dm_db_resource_stats;