Azure SQL Database
An Azure relational database service.
6,019 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
way to figure out current usage of reads and writes rates against Azure SQL DB
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].