Name: Peter Shore - Secrets of the Plan Cache
Start: 2021-09-23T17:45:00-04:00
End: 2021-09-23T19:45:00-04:00

You have heard of a query plan, right? Perhaps even looked at one somewhere a long the way. Have you ever wondered what information might be buried in the plan cache, the courses of action having
that additional information might lead you to? Perhaps you have wondered what plans in cache would benefit from those missing indexes or contemplated your cost threshold of parallelism, among other
questions. This session is designed to answer just that. We will look at query plans without the pretty node icons and from there we will interrogate the plan cache thus putting its secrets to work for us.

Peter is a seasoned IT professional with over 25 years of experience, a frequent speaker at SQL Saturday, User Groups, and other conferences. He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell. Peter is comfortable working with both physical and virtual servers where he tries to apply best practices to attain performance improvements. He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.

Additionally, Peter is the president of CBusPASS in Columbus, Ohio and co-organizer of SQL Saturday Columbus.

akhil mahajan

CincyDATA - Cincinnati Data and AI Users Group

Technology

.NET

Database Professionals

SQL Server

Hadoop

Big Data

Database Development

Data Analytics

SQL Azure

Business Intelligence & Data Warehousing

Peter Shore - Secrets of the Plan Cache

Online event

Share

CincyDATA - Cincinnati Data and AI Users Group

Peter Shore - Secrets of the Plan Cache

CincyDATA - Cincinnati Data and AI Users Group

Details

Members are also interested in