In this advanced session, Pinal Dave delves into sophisticated SQL Server tuning techniques designed to help experienced DBAs push their database systems to peak performance. Building on fundamental optimization concepts, this presentation offers in-depth strategies for diagnosing and resolving performance bottlenecks, advanced indexing tactics, and the effective use of SQL Server's built-in tools for performance analysis and tuning. Gain insights into fine-tuning your SQL Server instances through comprehensive discussions on partitioning, in-memory technologies, and the art of balancing workload and resource allocation. Tailored for seasoned professionals, this session empowers you to achieve top-tier performance, ensuring your SQL Server environment is optimized for speed, efficiency, and scalability.
Topics that will be discussed include:
- Advanced strategies for diagnosing and resolving performance bottlenecks
- Sophisticated indexing tactics to enhance database efficiency
- Utilization of SQL Server’s built-in tools for performance analysis and tuning
- Fine-tuning SQL Server instances with partitioning and in-memory technologies
- Balancing workload and resource allocation for optimal performance
Speaker: Pinal Dave, SQL Server performance tuning expert and independent consultant at SQL Authority.