SQL Friday newsletter #10 - SQL Friday is back!
Magnus Ahlkvist
SQL Server Specialist @ Transmokopter SQL AB | Microsoft Data Platform MVP
Finally, a new season of SQL Friday can start. We start this Friday (October 18) with a fairly new speaker from the Data Community - Haripriya Naidu
When: 18 October, at noon Central European Time
An attempt to live-stream the event to YouTube will be made, but due to changes in how New Teams use NDI, I'm not sure it will work, and therefore there's no YouTube livestream link in the invitation this time.
TempDB Contention: How to Identify and Resolve it
As a DBA, you know that TempDB performance is crucial to overall health and server performance. At the same time, you have tons of concurrent tasks running on your server that depend heavily on TempDB, causing a slowdown in performance.
In this session, I'll cover how the allocation of resources and workspace on TempDB is being managed. Next, I'll show you how to analyze the causes of contention and explore methods to identify and fix them. This includes configuring, and monitoring the TempDB to operate optimally on production servers.
Finally, I'll show you a demo on how to mitigate each of the contention types and how it varies across SQL Server versions.
By the end of this session, you will be able to address and resolve TempDB contention promptly, ensuring optimal TempDB performance in your SQL Server.
About Haripriya Naidu
Haripriya Naidu has been working as a SQL Server Database Administrator for 10 years in Boston, MA. She is passionate about databases and enjoys delving into SQL Server engine internals and optimizing performance. Additionally, she is an AWS Certified Solutions Associate and won the "Rookie of the Year" Award at work for 2023.
She actively participates in the New England SQL Server User group, attends SQL Saturdays, and engages in multiple online learning communities. These activities fuel her passion for learning and sharing insights within the SQL community.
She loves eagerly sharing knowledge with her teams.
She finds joy in reading non-fiction books. Her favorite moments are spent at beaches with her family.
Being a SQL enthusiast, a perpetual learner, and a family person defines her interests and passions.