June 15, 2021 PASSMN Meeting (Virtual Meeting Only)

Important Note: This meeting is online only and will not be held at the Microsoft Technology Center

Time: Jun 15, 2021 03:30 PM Central Time (US and Canada)

Join Zoom Meeting
https://us02web.zoom.us/j/83386812515?pwd=b3dzVnh0SE5JaWJ0NU9XWlFqZUJJQT09

Meeting ID: 833 8681 2515
Passcode: 020107

One tap mobile
+13126266799,,83386812515#,,,,020107# US (Chicago)
+16465588656,,83386812515#,,,,020107# US (New York)

Dial by your location
+1 312 626 6799 US (Chicago)
+1 646 558 8656 US (New York)
+1 301 715 8592 US (Washington DC)
+1 346 248 7799 US (Houston)
+1 669 900 9128 US (San Jose)
+1 253 215 8782 US (Tacoma)
Meeting ID: 833 8681 2515
Passcode: 020107

3:30-4:00 Kickoff / Announcements /New Horizons
4:00-5:00 Leveraging Execution Plans to Reduce Resource Use (Erin Stellato) **Continued
5:00-5:10 Break
5:10-6:10 Leveraging Execution Plans to Reduce Resource Use (Erin Stellato)
6:10-6:15 Closing

Meeting Sponsor: New Horizons' (https://www.newhorizons.com/)

New Horizons is one of the world's largest and leading providers in IT training, professional development, and certification preparation. Along with being official training partners with Microsoft, Cisco, CompTIA, VMware, and ITIL we have trained over 30 million people worldwide since 1982! New Horizons is designed to help everyone from busy IT professionals on corporate teams to your next door neighbor looking for a career change! New Horizons offers learning methods for all individuals from learning in a structured classroom setting online in real time with a real instructor to online anytime at your own pace! Turn ambitions into marketable skills and business goals into tangible results with training from New Horizons of Minnesota & Chicago!

Presentation topics, abstracts, speaker bio for this meeting:

Erin Stellato

Topic:
Leveraging Execution Plans to Reduce Resource Use

Abstract:

Performance tuning is cool - who doesn't love making something that's slow go faster? But tuning is not just about duration, it's also about reducing resource use which not only makes a query go faster, but also creates more capacity on the server.

There are multiple facets to tuning, with execution plans front and center. If you want to understand why a query requires a lot of I/O or CPU, then you need to see what's happening inside the engine.

In this session we'll start with a quick review of where we can find execution plans, and then we'll look at them in detail. In addition to talking about operators, how they work, and what to watch out for, we'll also dive into the not-so-obvious information in a plan which can be extremely valuable when troubleshooting and tuning. Expect to leave this session with practical information about execution plans that you can put to use immediately.

Speaker:

Erin Stellato is a Data Platform MVP and lives in Cleveland, OH. She has over 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Extended Events, Query Store, and helping accidental/involuntary DBAs figure out how SQL Server works. Erin is an active member of the SQL Server community, helps with her local user group, and is a regular speaker at conferences including SQLintersection, SQLBits, and the PASS Summit. Outside of time with family and friends, she enjoys running, reading, movies, and all things chocolate.

• Important to know

This meeting is online only and will not be held at the Microsoft Technology Center.