Cache configuration goals

Goals for configuring caches are:

In addition to commands such as showplan and statistics io that help tune on a per-query basis, you need to use a performance monitoring tool such as sp_sysmon to look at the complex picture of how multiple queries and multiple applications share cache space when they are run simultaneously.