SQL Server Performance Tuning and Optimization

SQT03 Fast Focus: The Top 5 Common Problems with SQL Server (and How to Fix Them)

11/16/2021

1:30pm - 1:50pm

Level: Intermediate

Thomas LaRock

Manager, Data Engineering

BlackLine

Every system administrator knows the four common resource bottlenecks: memory, CPU, disk, and network. But those resource bottlenecks are not the reason for your sudden performance issues. Over the years I've compiled a list of issues I find to be common with SQL Server. These issues are avoidable but not easy to fix once they have become a problem.

In this interactive session, we will review the top five common problems with SQL Server and discuss how to fix them.

You will learn:

  • Identify bottlenecks
  • Performance tuning
  • Query optimization