SQL Server Mission-Critical: Performance Tuning
This 1-day 300-level seminar focuses on performance and tuning tasks: architecture, memory, waits and events, storage, CPU, DML processing, concurrency, TempDB considerations, and diagnostics toolsets in a scale-up or scale-out infrastructure. Throughout the course, students are exposed to the art of tuning many key components of the SQL Server 2008 environment through seminar content and demonstrations. Performance and tuning best practice methodologies are emphasized demonstrated. The course covers a broad spectrum of topics, including Defining Performance Requirements, Designing Data Collection scenarios and various diagnostic approaches, Defining the SQL08 engine architecture, Best Practices for physical database design, Performance and Configuration considerations, DML and indexing best practices, Storage and Architectural considerations (RAID, SAN, remote storage, backup and recovery) and Operations and Management considerations for large SQL Server installations. Learn from the best: this content was developed by Scalability Experts, who are well-renowned for their enterprise SQL Server consulting services.
For over seven years Larry Chesnut has been an architect at Scalability Experts, Inc. His consulting engagements have involved many different industries and span both national as well as international customers. He has over 12 years of experience with SQL Server, starting with version 6.5. Before joining Scalability Experts he was a support specialist with Microsoft Developer Support (PSS) for SQL Server for over 5 years. While at Scalability Experts, he has delivered talks at conferences and workshops involving the upgrading, consolidation, scalability, capacity planning, load\stress testing, and high availability of SQL Server. When Scalability Experts was chosen as an Expert Content Providers (ECP) to develop and deliver training around the world for SQL Server 2005 Database Infrastructure course, Larry was on site with Microsoft for months working to develop the content. Afterwards, he traveled around the world twice over conducting SQL Server 2005 and later SQL Server 2008 Application Compatibility labs for ISV’s on behalf of Microsoft.
Register Now for PASS Summit 2010!