Ohio North SQL Server User Group

Choose a meeting below to view its details


Meeting Archive

Tuesday,

June

07

ONSSUG June Meeting

  • In-Person @ 6050 Oak Tree Blvd. Independence, Ohio, United States (map)
  • 17:00 - 19:00 Eastern Daylight Time
  • Language: English

Eventbrite link for RSVP : 

https://www.eventbrite.com/e/ohio-north-sql-server-user-group-onssug-june-meeting-67-tickets-25544904497


5:00 - 6:00 - Pre-Session Video

AlwaysOn in SQL Server 2016

Kevin Farlee
Track: Enterprise Database Administration & Deployment
Level: 300General Session (75 minutes)

Featured Presentation:

Answering the question, "What happened?" with Query Store

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 and try to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature. In this session we'll explore the Query Store feature using the latest CTP of SQL Server 2016. We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, and see how you can force SQL Server to use a specific plan for a query.

About Erin:
Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand 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 including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies, and all things chocolate.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids