July Meeting Nash SSUG: Kevin Kline at NSS

Event Information

Share this event

Date and Time

Location

Location

500 Interstate Blvd S, Suite 300 Nashville, TN 37210

View Map

Event description

Description

Kevin Kline

Four Ways We Kill the SQL Server Plan Cache

Level: 200

SQL Server’s plan cache is one of the largest regions of memory and is used to store all SQL queries and T-SQL code for quick execution. It is largely self-maintaining and self-tuning. However, the kind of queries you write and the way you invoke those queries can have an enormous impact on how the plan cache is maintained, tuned, and optimized. If you don’t do things right, you could end up shooting yourself in the foot and making performance much worse. Attend this demo-loaded session to learn about 4 harmful anti-patterns that developers frequently use without knowing their drawbacks.

This session will answer questions like:

- What’s currently in the plan cache?

- How often is the code in my plan cache being reused?

- Where are the big opportunities to save space in the plan cache?

- What coding techniques are most likely to make my object recompile unnecessarily or cause SQL Server to cache inefficient query plans?

There are a short list of mistakes that, if you know of them in advance, will make your life as a database developer much easier. Learn to avoid these four harmful anti-patterns which can slow down the plan cache. Learn how see what is in your SQL Server’s plan cache and how it is behaving. And embrace these recommended techniques to repair poorly performing queries or entirely avoid them in the first place.

Prerequisites: Basic understanding of SQL Server architecture and tools, basic SQL query knowledge.

Kevin Kline is a technology evangelist at SQL Sentry, an award-winning database tools provider. Kevin is a longtime Microsoft SQL Server MVP, is a founder and former president of PASS and the author of many books such as 'SQL in a Nutshell'. Kline tweets at @kekline and blogs at http://blogs.sqlsentry.com/KevinKline.

Sponsored by:

Robert Half

Founded in 1948, Robert Half International (NYSE: RHI) is the world’s first and largest specialized staffing firm. With more than 360 locations worldwide, Robert Half is dedicated to providing you highly skilled professionals whose skills are well-matched to your unique hiring requirements and workplace environment.

Robert Half has built a stellar reputation for high ethical standards, a specialized focus and unparalleled service. As one of the only truly global specialized staffing firms focusing exclusively in professional positions, Robert Half continues to help businesses worldwide find the skills they need, while assisting untold numbers of job seekers in finding meaningful employment.

For more than 15 years, Robert Half has been named to FORTUNE® magazine’s list of “Most Admired Companies.”

Location:

Nashville Software School

500 Interstate Blvd S, Suite 300

Nashville, TN 37210

The location is just off of Nolensville Pike, between I-40 and I-440.

Date and Time

Location

500 Interstate Blvd S, Suite 300 Nashville, TN 37210

View Map

Save This Event

Event Saved