SQL Server Performance Tuning and Optimization

SQW11 Configuring SQL Server for Performance… Like a Microsoft Certified Master


4:00pm - 5:15pm

Level: Intermediate

Thomas LaRock

Head Geek


Great database performance starts with great database design. That design includes both the logical and physical design details. The best DBAs tune SQL Server for performance at the server, instance and database layers. This allows for both the logical and physical database designs to meet performance expectations. However, it can be difficult to know which configuration options are better than others. Attend this session and learn which options are right for which workloads.

You will learn:

  • How to detect non-optimal SQL Server configurations
  • How to configure SQL Server for maximum performance
  • The configuration options available at the server O/S, SQL instance, and database layers