SQL Server Performance Tuning and Optimization

SQW08 Ancient Problems and Modern Solutions: Troubleshooting CPU in SQL


1:45pm - 3:00pm

Level: Intermediate to Advanced

Pinal Dave

MS Computer Science

SQL Server Performance Tuning Expert

DBAs are in a challenging situation when they see CPU running at 100 percent. There are many solutions of this situation, but very little time to implement those solutions. In this critical situation, developers need a sure solution that gives stability to their system and buys more time to troubleshoot the problem. Many believe Performance Tuning and Troubleshooting is an art that has been lost in time. The truth is that art has evolved with the time and there are more tools and techniques to overcome ancient troublesome scenarios. There three major resources when bottlenecks create performance problems: CPU, IO, and Memory. This session will focus on some of the common performance issues and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

You will learn:

  • Understand how each of the three important resources impact SQL Server Performance. We will focus on CPU, IO and Memory
  • The CPU is a very critical resource for the SQL Server and it is often spotted at very high consumption level. We will understand the true meaning of the high consumption and its significance
  • Tricks and tips which keep the CPU under reasonable baseline and ensures smooth transactions of query performance