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
Nov 2019 Tue 11/19/2019
Speaker: Kevin Boles
Topic: Common TSQL Mistakes
Speaker: Shawn Weisfeld
Topic: Quick Introduction to GitHub
Dec 2019 Tue 12/17/2019
Speaker: Jay Falck
Topic: Setting up a test lab with Hyper-V

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

Friday,

January

29

Precon for SQL Saturday Austin #461 - Performance Tuning Like a Boss

1209 N IH 35
Round Rock, Texas 78664
Time: 09:00 - 16:30

Special Notes:

MUST REGISTER AND PAY AT: http://sqlsat461-perf.eventbrite.com

Title:   Performance Tuning Like a Boss

Speaker: Robert Davis

Abstract:  Performance tuning uses troubleshooting techniques that you can adopt for your own. It’s not just trial-and-error, and it’s definitely not magic unicorn dust. You will learn to recognize the difference between symptom and root cause to address the real underlying issue. Dive deeper into some of the common problems that are the most difficult to prevent, diagnose, and correct.

Some of the troubleshooting methods covered will include waits and queues, performance monitoring, baselining, and benchmarking. Equally as important as learning what to do, you will also learn how to avoid common pitfalls -- or what not to do.

We will also take an in-depth look at the new performance tuning tools coming in SQL Server 2016: Query Store, Live Query Statistics, and Query Plan Comparisons. These tools are going to change how SQL professionals identify and tune problem queries. They are the biggest change to performance tuning since Dynamic Management Views were introduced in SQL Server 2005.

Full list of topics:

  • Configuring SQL Server for Optimal Performance
  • Memory, parallelism, tempdb
  • Diagnosing Poor Performance with Wait Statistics
  • Tuning Queries with Execution Plans
  • Indexing for Performance
  • Identifying and Remediating Plan Regression With Query Store and Query Plan Comparison
  • Using Live Query Statistics to identify Bottlenecks in Query Plans

Learning Objectives:

  • Learn how to identify and fix the root cause of performance problems rather than just reacting to the symptoms
  • Understand how to proactively prevent common performance problems by configuring SQL Server to perform optimally
  • Discover how the new performance tuning features of SQL Server 2016 can take your performance tuning skills to whole new levels of greatness
  • Gain the confidence to know you can take on any performance problem and come out looking like the hero.

Session Prerequisites:

  • Basic familiarity with Dynamic Management Views (DMVs) and query plans
  • A desire to be the person everyone looks for when there is a performance issue

Speaker Bio: Robert L Davis is a Microsoft Certified Master in SQL Server and a SQL Server MVP. He is an experienced author, trainer, and has 16 years of experience working with SQL Server as a DBA, SQL developer, and database architect. He has worked as a production DBA and architect/developer at Microsoft, a Principal Database Architect for DB Technologies, and currently works as a Database Engineer for BlueMountain Capital Management.

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