SQL Server Performance Tuning and Optimization

SQW07 Configuring SQL Server for Performance Like a Microsoft Certified Master

12/07/2016

1:45pm - 3:00pm

Level: Intermediate

Thomas LaRock

Head Geek

SolarWinds

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 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