Real World Database Configuration and Tuning for SQL Server 2012

Full Day Workshop on Configuring and Tuning SQL Server convering architecture to bare metal tuning to monitoring and performance tuning.

Kevin Kline is the Director of Engineering Services at SQL Sentry, and a founding board member & former President of the international Professional Association for SQL Server (PASS).

A top rated speaker, Kevin appears at international conferences like Microsoft TechEd, DevTeach, PASS, Microsoft IT Forum, SQL Connections, and the Best Practices Conference.

When Kevin isn't working on technology issues, he enjoys spending time with his wife Rachel, his four kids, his three stepkids, and his Basset Hound and Ginger Kitty.

Kevins blog URL is
http://kevinekline.com.
And he also tweets at
http://twitter.com/kekline.

This full-day training event combines a thorough overview of key concepts followed by hands-on demos to reinforce each conceptual lesson. Since most technologists learn by doing, this training is designed to maximize the time attendees spend working with SQL Server. With ample demos, we’ll cover the spectrum of best practices as they relate to server and database design & configuration and performance tuning.

This is a level 200-300 session.

Basic understanding of SQL Server Management Studio (SSMS), SQL Server architecture and administration.

At the conclusion of the training, attendees will understand:

• The internals and architecture of SQL Server and how they interact during read and, separately, during write operations, including an overview of SQL Server caches, memory buffering and clean-up processes, and user activity handling
• An introduction to bare-metal tuning of server hardware and storage configurations for database applications, including DASD, RAID, SSD, and SAN architectures
• Important Windows and SQL Server configuration settings and trace flags, including special considerations for SQL Server running on VMs
• Methods for benchmarking the performance of alternative configurations and settings
• Designing databases for performance through indexing, statistics and cardinality, data types, and recovery mode
• Monitoring and identifying performance bottlenecks and resolving performance issues, including PerfMon, traces and extended events, Dynamic Management Views (DMVs) and Wait Statistics
• Advanced database structures including “Hekaton” in-memory tables and Columnstore indexes