Welcome to the September 18th 1800 HRS PST/2100 HRS EST, 2024 HYBRID meeting!
We are once again meeting in person in Vancouver, WA at the downtown Umpqua Bank in their Community Room!
We meet on the 3rd Wednesday of the month once again at 6:00 PM PST. We will have snacks and networking before the main meeting.
But… we will continue to operate monthly online meetings through the PNW collaborative facilitated by the Oregon Data Community. Due to this, you will be able to attend the meeting remotely and we are definitely open to remote speakers.
Please Register at Meetup:
https://www.meetup.com/oregonsql/events/303298094/
In order to encourage questions during the presentation, please use chat which will be monitored and/or use the raise hands option in Teams. Please be mindful of the other attendees and mute your mic!
We will be starting at 6:00 PM PST/9:00 PM EST
Schedule: (may be fluid due to discussions and Q/A):
6:00 – 6:30 PM – Snacks/Announcements/Networking
6:30 PM – Presentation
8:30 PM – Happy Hour/Networking (Shanahans in Vancouver)
Presentation:
Title: Reworking Indexes for an Evolving Application
Abstract:
Performance issues in the database accumulate over time: poor architecture, growing data, and changing usage. In these situations, it’s important to identify the most problematic issues rather than the most visible.
In this session, we’ll discuss a systematic approach to triaging performance issues through functional index analysis. Learn the importance of understanding table relationships and leveraging this knowledge to prioritize easy wins with significant gains. After all, a missing foreign key index, a suboptimal clustered index, or even a too-short non-clustered index can each have a substantial impact on performance.
I’ll share my strategy for analyzing key metrics and determining next steps to optimize design within the context of the application instead of simply by the book.
I’ll also demonstrate how to translate these insights into action by refactoring existing indexes, adding new ones, and streamlining overall performance. By the end of this session, you’ll have a strategy for assessing the health of your database design and making methodical improvements, even when the only data point they give you is “slow”.
Bio:
Courtney Woolum is a SQL Server DBA with a decade of experience in database and server management. She is passionate about teaching and delights in sharing new techniques and expanding skill sets with anyone who will listen. With a background in mathematics, Courtney thrives on the problem-solving aspect of optimizing processes and performance in an ever-changing landscape. When not multitasking at her desk, you can find her with her son, in her craft room, or attempting to catch some sleep — possibly all at the same time.
Here’s Courtney!
