Get Live Help
The number of physical database page writes issued during the specified time range.
The rate per second of probe scans. A probe scan is used for directly looking up rows in an index or base table.
The Plan Cache is an area in the SQL Server memory, used for storing objects such as stored procedures, ad hoc and prepared Transact-SQL statements, and triggers.
The plan cache hit ratio indicates the ratio between physical accesses and logical accesses, that is, how much work (for example, I/O and compilations) is being saved by finding the required information already in the plan cache.