Session 2: Understanding Query Plan Reuse

Presented by: Andrew Kelly

Running Time: 63 minutes

Reusing a previously compiled query plan is one of the keys to achieving peak performance with a busy SQL Server instance. As such, understanding the fundamentals of how SQL Server stores and re-uses query plans is essential to scalability and performance. See what affects plan reuse and learn the proper way to submit calls to SQL Server in order to maximize the benefits associated with plan reuse.

Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish