Allow me to take a moment to introduce you to the upcoming Optimizing Database Performance webcast on LinkedIn, Feb 26, 10:00 a.m., U.S. CT. This is the first in a planned multi-part series.
A Gentle Introduction
Episode one features the solid foundations of database design. It covers the concepts of building and maintaining an application using a relational database back end, such as Microsoft SQL Server. This session is great for anyone wanting to learn more about relational databases and their work behind the scenes.
By “solid foundations,” I mean in a narrative sense. I’ll use analogies and animations to explain how relational databases process user requests without bogging you down with difficult-to-understand jargon and obscure details. Note that we will point you to deeper resources such as white papers, articles, and blogs detailing the various technical aspects we discuss so you can get the inside scoop if you want more.
During our 45-minute session, we'll review essential database design elements. For example, we'll learn how the relational databases use tables and indexes to accelerate SELECT statements, which can cause more harm than good if they aren’t created properly.
We will also look at the lifecycle of an SQL transaction, to fully understand how SQL workloads interact with the backend relational database and how that database server utilizes memory, CPU, and IO to complete requested workflows. Sometimes, all it takes is a poorly formed query to completely tank database performance and limit scalability.
Finally, we'll look at typical performance pitfalls and suggest strategies to prevent them. We will examine locking, blocking, and deadlocking and how the overall wait statistics accumulated during routine transactional workload processing can point you to the next step in your troubleshooting process.
Register Today and Share
So, please take a moment to register for the webcast, and block time on your calendar for the follow-up webcast in March while you’re at it. In episode two, we’ll cover SQL anti-patterns and discuss ways to improve the performance of your relational database through better SQL code.
I’ll see you on Wednesday, Feb 26, 10:00 – 10:45 a.m., U.S. CT.
Bring your questions and tell a friend or share the post.
Register Here
