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

Question

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

Answer 1

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].