Sacramento SQL Server User Group

Next Meeting

Wednesday,

September

06

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

  • Patrick Hays Learning Center (map)
  • 2700 Gateway Oaks Drive, Suite 2600
  • Sacramento, CA 95833
  • 6:00 PM to 8:00 PM
  • RSVP via Meetup

Sacramento SQL Server User Group September 2017 Meeting

Featured Presentation:

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

Erin Stellato, Principal Consultant SQLskills

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!

About Erin:
Erin Stellato is a Principal Consultant with SQLskills 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 internals, performance tuning, and high availability and disaster recovery. Erin is a SQL Server MVP and an active member of the SQL Server community. She is involved with the Ohio North SQL Server User Group and blogs at SQLskills.com/blogs/erin. You can find her on Twitter at @ErinStellato.

Meeting Schedule and Structure

The Sacramento SQL Server User Group meets the first Wednesday of every month. Most meetings will have a presentation, while others are open group sessions which allow attendees to discuss SQL Server questions, issues and news as a group.

We start each meeting with some time to network and get situated. Unless otherwise noted, the schedule for each meeting will be:

6:00 PM - 6:15 PM: Mingle/networking, get food & beverages, presentation setup
6:15 PM - 6:30 PM: Group announcements, agenda, introduce speaker
6:30 PM - 7:30 PM: Presentation
7:30 PM - 8:00 PM: Post-meeting discussions

Announcements

PASS Summit 2017 Registration Discount Code:
Save $150 with the SACSQLUG registration discount code LC15QXQ4 for PASS Summit 2017

SQLSaturday Sacramento 2017 (SQLSaturday #650, #sqlsatsac):
SQLSaturday Sacramento 2017 (SQLSaturday #650) was July 15, 2017.
http://www.sqlsaturday.com/650/EventHome.aspx

Our Sponsors

PASSChapterLogo100.jpg

 

Back to Top