Why should I care about the plan cache?
Enterprise Database Administration & Deployment
SQL Server is a huge product, with many different places a DBA can go to look for information on how the server is performing. So many in fact that they can often overlap, which sometimes makes it hard to understand why tackling a new tool is worth the effort. In this first (and hopefully not last) installment of Rick's "Why should I care" series a case for why working knowledge of how to query the plan cache is critical for performance tuning efforts in real world environments, followed by a review of relevant DMV's for the newly motivated audience. Perfect for those who are relatively new to performance tuning concerns, or advanced DBAs trying to figure out how to have a similar conversation with their less experienced peers, or developers who are curious as to why their DBA is sometimes so moody.