SQL Server, HTTP Storage object

Applies to: yesSQL Server (all supported versions)

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/Read BASE For internal use only.
Avg. Bytes/Transfer Average number of bytes transferred from the HTTP storage during read or write operations.
Avg. Bytes/Transfer BASE For internal use only.
Avg. Bytes/Write Average number of bytes transferred from the HTTP storage per write.
Avg. Bytes/Write BASE For internal use only.
Avg. microsec/Read The average number of microseconds it takes to do each read from the HTTP storage.
Avg. microsec/Read BASE For internal use only.
Avg. microsec/Read Comp The average number of microseconds it takes for HTTP to complete the read to storage.
Avg. microsec/Read Comp BASE For internal use only.
Avg. microsec/Transfer The average number of microseconds it takes to do each transfer to the HTTP storage.
Avg. microsec/Transfer BASE For internal use only.
Avg. microsec/Write The average number of microseconds it takes to do each write to the HTTP storage.
Avg. microsec/Write BASE For internal use only.
Avg. microsec/Write Comp The average number of microseconds it takes for HTTP to complete the write to storage.
Avg. microsec/Write Comp BASE For internal use only.
HTTP Storage IO failed/sec Number of failed write requests sent to the HTTP storage per second.
HTTP Storage IO retry/sec Number of retry requests sent to the HTTP storage per second.
Outstanding HTTP Storage IO 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.

Example

You begin to explore the query performance counters in this object using this T-SQL query on the sys.dm_os_performance_counters dynamic management view:

SELECT * FROM sys.dm_os_performance_counters
WHERE object_name LIKE '%HTTP Storage%';

See also

Monitor Resource Usage (System Monitor)