Presented by Andrew Kelly
Running Time: 77 min
To get peak performance from your SQL Server instance, you need to ensure that the majority of your database calls reuse a previously compiled query plan. Lack of proper plan reuse can add an enormous amount of overhead to your system and can affect overall performance. We will start with an overview of how the plan cache works, which will help you identify the existing plans that aren't being reused—and more importantly, we'll show you how to reverse that behavior. Finally, we'll explore several options for dealing with situations in which you might not have control over how calls are made to the database.