SQL Server - Monitoring Logical and Physical Reads & Buffer Cache Usage
Monitoring Logical and Physical Reads & Buffer Cache Usage
Many SQL Server performance problems will come down to poor physical disk performance or inadequate memory resource. This article takes a look at the Buffer Cache and some of the tools that we have for troubleshooting poorly performing SQL Server instances and queries.
Throughout this article we will meet a number of Dynamic Management Views, Functions and System Views: