SQL Server, HTTP Storage

APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

The SQLServer:HTTP Storage performance object consists of performance counters that monitor a Microsoft Azure Storage account. Using SQL Server Data Files in Microsoft Azure feature, you can store database files in Azure Storage Blobs. This performance object treats each Azure Storage account as a different drive.

Counter Name Description
Avg. Bytes/Read Average number of bytes transferred from the HTTP storage per read.
Avg. Bytes/Transfer Average number of bytes transferred from the HTTP storage during read or write operations.
Avg. Bytes/Write Average number of bytes transferred from the HTTP storage per write.
Avg. microsec/Read The average number of microseconds it takes to do each read from the HTTP storage.
Avg. microsec/Read Comp The average number of microseconds it takes for HTTP to complete the read to storage.
Avg. microsec/Transfer The average number of microseconds it takes to do each transfer to the HTTP storage.
Avg. microsec/Write The average number of microseconds it takes to do each write to the HTTP storage.
Avg. microsec/Write Comp The average number of microseconds it takes for HTTP to complete the write to storage.
HTTP Storage IO failed/sec Number of failed write requests sent to the HTTP storage per second.
HTTP Storage I/O retry/sec Number of retry requests sent to the HTTP storage per second.
Outstanding HTTP Storage I/O The total number of outstanding I/Os towards a HTTP storage.
Read Bytes/sec Amount of data being transferred from the HTTP storage per second during read operations.
Reads/sec Number of reads per second on the HTTP storage.
Total Bytes/sec Amount of data being transferred from the HTTP storage per second during read or write operations.
Transfers/sec Number of read and write operations per second on the HTTP storage.
Write Bytes/sec Amount of data being transferred from the HTTP storage per second during write operations.
Writes/sec Number of writer per second on the HTTP storage.

See Also

Monitor Resource Usage (System Monitor)