This advanced session led by Pinal Dave explores sophisticated SQL Server tuning techniques to help experienced DBAs elevate their database systems to high performance. Building on fundamental optimization concepts, this presentation explores in-depth strategies for diagnosing and resolving performance bottlenecks, advanced indexing tactics and the utilization of SQL Server's built-in tools for performance analysis and tuning. You’ll 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. Designed to extend the knowledgebase of seasoned professionals, this session will empower you to achieve peak performance, ensuring your SQL Server environment is optimized for speed, efficiency and scalability.
Intervenants
Pinal Dave is a SQL Server performance tuning expert and independent consultant with more than 22 years of hands-on experience. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,700 database tech articles on his blog.