CACTUSS North

CACTUSS

Capital Area Central Texas User of SQL Server

PASS affiliated user group for Austin, TX

Contact us: Email: CACTUSS.SQL (at) (gmail) (dot) (com)
Twitter: @CACTUSS_SQL
LinkedIn: https://www.linkedin.com/groups/149440
Meetup: https://www.meetup.com/Austin-SQL-Server-User-Group/

Upcoming Meeting Dates

  North
Aug 2019 Tue 8/20/2019
Speaker: Mike Byrd
Topic: A Self-Tuning Fill Factor Technique for SQL Server
Sep 2019 Tue 9/17/2019
Speaker: Jay Falck
Topic: Setting up a test lab with Hyper-V
Oct 2019 Tue 10//21/2019
Speaker: Open
Topic: Submit Your Topic
Nov 2019 Tue 11/19/2019
Speaker: Open
Topic: Submit Your Topic

 


Meeting Location

CACTUSS North

  • Meeting dates: 3rd Tuesday of the month
  • Meeting starts: 5:30 pm with food and a QA session
  • Presentation: 6:00 pm and goes to 7:15 pm
  • Address
    • Quarry Oaks II
    • Microsoft Office
    • Suite 225
    • 10900 Stonelake Blvd.
    • Austin, TX 78759
      • * Free parking
      • * Coming from Braker, go right/straight at the traffic circle and it's the building on the left.
      • * The building is also across from the outdoor basketball court
      • * Not the building attached to the parking garage
      • * Inside the Microsoft office, go right, past the reception desk, to the far back and left
      • * If there is interest, there is sometimes an after-gathering at a local place to talk casually
    • Map: http://binged.it/1HOSMWm

Next Meeting

Tuesday,

October

20

Troubleshooting Plan Changes with Query Store in SQL Server 2016

10900 Stonelake Blvd. Suite 225 - Microsoft Office
Austin, Texas 78759
Time: 18:00 - 20:00

Title: Troubleshooting Plan Changes with Query Store in SQL 2016
by: John Sterrett

Summary: ve you ever had random performance problems with a particular query? Have you noticed different execution plans for the same query? In this session were going to cover how execution plans get invalidated and why data skew could be the root cause to seeing different execution plans for the same query.  We will look at options for forcing a query to use a particular execution plan. Finally, you will learn how this complex problem can be identified and resolved simply using a new feature in SQL Server 2016 called Query Store.   Goals:  1. Learn how execution plans are created and removed from plan cache 2. Understand how and why execution plans change 3. Learn how to lock in an execution plan for a given query.

Speaker: John Sterrett, Principal Consultant Procure SQL LLC:
Bio: John Sterrett is an MCSE: Data Platform, Principal Consultant and the Founder of Procure SQL LLC. John has presented at many community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and the founder of the HADR Virtual Chapter.

Special Notes:
ve you ever had random performance problems with a particular query? Have you noticed different execution plans for the same query? In this session were going to cover how execution plans get invalidated and why data skew could be the root cause to seeing different execution plans for the same query.  We will look at options for forcing a query to use a particular execution plan. Finally, you will learn how this complex problem can be identified and resolved simply using a new feature in SQL Server 2016 called Query Store.
 
Goals: 
1. Learn how execution plans are created and removed from plan cache
2. Understand how and why execution plans change
3. Learn how to lock in an execution plan for a given query.


Available Attachments:

Our monthly meetings are made possible by the generosity of these sponsors:

This month's sponsor:

(Feature coming soon)

Ongoing sponsors:

Microsoft

SQL Watchmen  

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