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

Vijay Kumar 1,936 Reputation points

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 26,121 Reputation points MVP

    You can try the following query:

    SELECT db_name = DB_NAME(vfs.database_id),vfs.database_id,  
    	[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].

0 additional answers

Sort by: Newest