Cache Hit Rates chart | Spotlight Enterprise Documentation

The Cache Hit Rates chart shows the Hit Rates for the main SQL Azure caches.

A Hit Rate indicates how much work (I/O or compilations) is being saved by caching information in memory.

Hit rates are shown for the following Caches:

Buffer Cache
Procedure Cache - the hit rate for this cache will vary widely depending on how the application is written. This figure is averaged for all procedure cache object types except ad hoc SQL.

Spotlight calculates its hit rates using a differential sampling method. Unlike most SQL Azure monitors, it is NOT reporting the average hit rate since SQL Azure started.