SQL Server, HTTP_STORAGE_OBJECT

SQL Server 2016 and later
 

Applies To: SQL Server 2016

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

Counter NameDescription
Read Bytes/secAmount of data being transferred from the HTTP storage per second during read operations.
Write Bytes/secAmount of data being transferred from the HTTP storage per second during write operations.
Total Bytes/secAmount of data being transferred from the HTTP storage per second during read or write operations.
Reads/secNumber of reads per second on the HTTP storage.
Writes/secNumber of writer per second on the HTTP storage.
Transfers/secNumber of read and write operations per second on the HTTP storage.
Avg. Bytes/ReadAverage number of bytes transferred from the HTTP storage per read.
Avg. Bytes/Read BASEFor internal use only.
Avg. Bytes/TransferAverage number of bytes transferred from the HTTP storage during read or write operations.
Avg. Bytes/Transfer BASEFor internal use only.
Avg. Bytes/WriteAverage number of bytes transferred from the HTTP storage per write.
Avg. Bytes/Write BASEFor internal use only.
Avg. microsec/ReadThe average number of microseconds it takes to do each read from the HTTP storage.
Avg. microsec/Read BASEFor internal use only.
Avg. microsec/Read CompThe average number of microseconds it takes for HTTP to complete the read to storage.
Avg. microsec/Read Comp BASEFor internal use only.
Avg. microsec/WriteThe average number of microseconds it takes to do each write to the HTTP storage.
Avg. microsec/TransferThe average number of microseconds it takes to do each transfer to the HTTP storage.
Avg. microsec/Transfer BASEFor internal use only.
Avg. microsec/Write BASEFor internal use only.
Avg. microsec/Write CompThe average number of microseconds it takes for HTTP to complete the write to storage.
Avg. microsec/Write Comp BASEFor internal use only.
Outstanding HTTP Storage I/OThe total number of outstanding I/Os towards a HTTP storage.
HTTP Storage IO failed/secNumber of failed write requests sent to the HTTP storage per second.
HTTP Storage I/O Retry/secNumber of retry requests sent to the HTTP storage per second.

Monitor Resource Usage (System Monitor)

Community Additions

ADD
Show: