Total Page Preview:   000000000547

Find Resource usage in Azure SQL Database using script or T-SQL

In this article, we will learn how to find resource usage in Azure SQL database using scripts or T-SQL.

Resource Usage In Azure SQL Database
 

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;

Result :

Resource Usage In Azure SQL Database

Thank You

About Author

Brijesh Kumar

Database Developer

I have more then 6 years Experience in Microsoft Technologies - SQL Server Database, ETL Azure Cloud - Azure SQL Database, CosmosDB, Azure Data Factory, PowerBI, Web Job, Azure Function, Azure Storage, Web Apps, Powershall and Database Migration On-Premise to Azure Cloud.
LinkedIn : https://www.linkedin.com



Comments







Facebook User: