Maximizing Plan Reuse - On Demand

Price: $39.95

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.

Your Shopping Cart

Sponsored Introduction Continue on to (or wait seconds) ×