Preventing SQL Server Performance Problems Before They Hit Production

Presented by Mark Allison,
Paul Anderton & Kevin Kline

Wouldn’t it be great if performance problems in your SQL estate could be detected BEFORE they reach your production databases? In this demo-centred webinar we will review:

  • How to detect and prevent releases of code that could reduce performance of your SQL Server database

  • Ways to prevent the most common performance problems before they reach production: missing indexes, deadlocks and excessive key lookups

  • How effective SentryOne can be in a DevOps pipeline both on-premise and in the cloud

  • How SentryOne can be used to highlight the usefulness of correlating data together to solve deployment problems quickly by creating Advisory Conditions that display data on the dashboards

 

Download the Recording

Mark Allison.jpg

Mark Allison
Sabin.IO

Mark Allison (@dataguzzle) is a DevOps Data Engineer working for Sabin.IO. Mark started on SQL Server 4.21 on OS/2 Warp :D, and has worked on every version since, including 2017 and Azure. He has worked as a DBA, a database developer, architect and now Devops Engineer. He received MVP award for SQL Server between 2002-2006.

Paul Anderton.jpg 

Paul Anderton
Sabin.IO

Paul Anderton (@sqlpanders) is a Microsoft Certified Master (MCM) and currently works as a Data Consultant for Sabin.IO. He has over 17 years experience in the IT industry, starting as a Network Administrator before becoming a SQL DBA, focusing on SQL Server for the past 14 years. His roles include Production DBA, Development DBA and SQL Developer and has worked with SQL Server since SQL Server 7.0. He also runs the Manchester SQL Server User Group and SQL Saturday Manchester.

kevin kline

Kevin Kline
SentryOne

Kevin (@kekline) is responsible for expanding SentryOne technical sales and marketing initiatives and is also involved in product design activities. He is a founder and former president of PASS and the author of popular IT books including SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com.