Level: Intermediate
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