way to figure out current usage of read and write rates against Azure SQL Db

Vijay Kumar 1,846 Reputation points
2022-06-16T20:55:05.02+00:00

way to figure out current usage of reads and writes rates against Azure SQL DB

Azure SQL Database
No comments
1 vote

Accepted answer
  1. Alberto Morillo 24,711 Reputation points Microsoft MVP
    2022-06-16T22:29:59.093+00:00

    You can try the following query:

    SELECT db_name = DB_NAME(vfs.database_id),vfs.database_id,  
    	[io_stall_read_ms],[io_stall_write_ms],[io_stall_queued_read_ms],[io_stall_queued_write_ms],[io_stall],  
    	[num_of_bytes_read], [num_of_bytes_written],  
    	[num_of_reads], [num_of_writes]  
    FROM sys.dm_io_virtual_file_stats (db_id(),NULL) AS [vfs]  
    

    Take a first snapshot, a second later take another snapshot and substract values obtained for num_of_reads] and [num_of_writes].

    No comments

0 additional answers

Sort by: Most helpful