Free

EDMPASS - Answering the Question, "What Happened?" with Query Store with Er...

Event Information

Share this event

Date and Time

Location

Location

CWB Building. 11th Floor

10303 Jasper Avenue, Edmonton, Alberta

Alberta

Canada

View Map

Friends Who Are Going
Event description

Description

One of the most highly anticipated new features in the SQL Server 2016 release is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely plans and runtime statistics. If you've ever had to drop everything to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature. In this session we'll walk through Query Store with a series of demos designed to help you understand how you can immediately start to use it once you’ve upgraded to SQL Server 2016. We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, see how you can force SQL Server to use a specific plan for a query, and find out what happens when it can’t use the specified plan. Get ready to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016!.

Erin is a Principal Consultant at SQLSkills


Erin Stellato is a SQL Server MVP and lives in Cleveland, OH. She has over 15 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include statistics, performance tuning, Extended Events, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences like SQLintersection and the PASS Summit. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.


Email:
Erin@SQLskills.com
Website:
http://www.SQLskills.com

Full Bio: http://www.sqlskills.com/about/erin-stellato/
Blog:
http://www.SQLskills.com/blogs/Erin
Twitter:
http://twitter.com/ErinStellato
SQL Server
MVP since 2012

NOTE: Due to renovations to the downstairs convention centre it will be held on the 11th floor

Share with friends

Date and Time

Location

CWB Building. 11th Floor

10303 Jasper Avenue, Edmonton, Alberta

Alberta

Canada

View Map

Save This Event

Event Saved