SQL Server Performance Tuning and Optimization

SQW12 Ancient Problems and Modern Solutions - Troubleshooting CPU


1:45pm - 3:00pm

Level: Introductory to Intermediate

Pinal Dave

MS Computer Science

SQL Server Performance Tuning Expert

This is the session for you to attend. Many believe Performance Tuning and Troubleshooting is an art which has been lost in time. The truth is that art has evolved with time and there are more tools and techniques to overcome ancient troublesome scenarios. In this session we will focus on High CPU scenarios detection and their resolutions. At the end of the session you will have clear ideas and action items regarding what to do when facing any of the above resource intensive scenarios.

You will learn:

  • Basics of Indexes
  • Basics of Performance Tuning
  • Advanced Tips and Tricks for Optimization