Real World Database Configuration and Tuning
Stacks Image 2

מק"ט: 301
מדריך: קווין קליין
תאריכים: 24-26/11
/2013

קורס מתקדם ומעשי שפותח ע"י קווין קליין המתמקד באומנות של תכנון ,הגדרה ויישום ב-SQL Server 2012 במטרה למקסם את הביצועים והמדרגיות.

Real World Database Configuration and Tuning is a 3-day class developed by Kevin Kline to train information technology professionals in the fine art of configuring and implementing Microsoft SQL Server for maximum performance and scalability

פרוט:

Training Objectives

At the conclusion of the training, attendees will understand:
• Bare-metal tuning of server hardware and storage configurations for database applications.
• Important Windows and SQL Server configuration settings, including virtual versus physical environments.
• Methods for benchmarking the performance of alternative configurations and settings.
• Designing databases for performance through indexing, data types, and recovery mode.
• Monitoring and identifying performance bottlenecks and resolving performance issues.
• Understanding SQL Server query performance through execution plan analysis and Dynamic Management Views (DMVs).

Lesson 1: SQL Server Internals and Architecture
• A fast-paced overview of the major components of SQL Server and how they interact during read and, separate, during write operations.
• An overview of SQL Server caches, memory clean-up processes, and user activity handling.
Lesson 2: The Fundamentals of Server Hardware Configuration
• Introduction to physical hardware componentry and to virtual servers.
• Demonstration of SQL Server Management Studio (SSMS) and basic performance monitoring tools, including PerfMon and Profiler .
Lesson 3: High-performance Storage
• Introduction to storage concepts, including DASD, RAID, SSD, and SAN architectures.
Lesson 4: Database and Storage Interaction
• Intermediate storage concepts, including database files, filegroups, and partitions. Discussion of advance storage concepts, specifically the SQL Server storage engine internals, such as database internal structures (GAMs, SGAMs, IAMs).  
• Demonstration of the primary benchmarking tool used in the class, HammerDB.
Lesson 5: Basic Windows and SQL Server Configuration Settings
• Overview of basic Windows and SQL Server configuration settings, including memory and CPU.
Lesson 6: Advanced Windows and SQL Server Configuration Settings
• Discussion of advanced configuration settings, such as Max Degrees of Parallelism, Query Threshold for Parallelism, and Optimize for Ad Hoc Workloads. 
• Discussion of important trace flags.
Lesson 7: Monitoring for Performance Bottlenecks and Problem Conditions
• Overview of SQL Server’s instrumentation including DMVs and Wait Statistics.
Lesson 8: Database Configuration Settings
• Discussion of database configuration settings, including parameterization, recovery mode, recovery interval, and automatic statistics maintenance. 
• A brief overview of important database design considerations for efficient backup and recovery.