Answering the Question, "What Happened?" with Query Store-Erin Stellato (Remote)

Sep 6, 2017 · Sacramento, United States of America

Answering the Question, "What Happened?" with Query Store - Erin Stellato (Remote)

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 Stellato (SQLskills Principal Consultant) 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: [masked] 
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

Sponsor: ZeekTek

Meeting location: 

2700 Gateway Oaks Drive is located in the Sutter Health business park at the northeast corner of the intersection of Gateway Oaks Drive and West El Camino in Sacramento.  The 2700 building is at the back of the complex; you can see I-5 from the parking lot.  Enter the building from the parking lot side, not the courtyard side.  Once inside the building, take the stairs or elevator to the second floor, then enter Suite 2600.  In the reception area, check the monitor to find our room for the evening and then proceed to that room.

Event organizers
  • Sacramento SQL Server User Group

    The Sacramento SQL Server User Group is a local chapter of the Professional Association for SQL Server (PASS). The mission of PASS is to empower data professionals who leverage Microsoft technologies to connect, share, and learn through networking, knowledge sharing, and peer-based learning. We meet the first Wednesday of each month (6PM to 8PM) to discuss anything SQL Server.  Additionally, we host a SQLSaturday event every July. We are new to Meetup.com, but we are not a new group; we've been meeting si

    Recent Events
    More

Are you organizing Answering the Question, "What Happened?" with Query Store-Erin Stellato (Remote)?

Claim the event and start manage its content.

I am the organizer
Social
Rating

based on 0 reviews