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

Vijay Kumar 1,846 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 24,711 Reputation points Microsoft 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].

    No comments

0 additional answers

Sort by: Most helpful