We all know the situation only too well, Friday evening and the weekend is flirting with you promisingly ….. then the dreaded email arrives telling you that your SQL Server has enormous performance problems. What can you do to identify the problem and resolve it quickly? Which SQL Server tools will help you rescue your free time?
In this 3-Day workshop Klaus will:
- Delve into the most prominent performance bottlenecks inside SQL Server
- Show you the different tools at your disposal to enable effective SQL Server performance troubleshooting.
- Teach you how to identify and resolve performance bottlenecks quickly.
Database Administrators, Developers and SQL Professionals seeking advanced troubleshooting techniques.
Pre-requisites
- Experience running SQL Server
- Fundamental index tuning and queryplan analysis skills
- Basic understanding of operating system
Day 1: Performance Tuning with Indexing
- Structures
- Fixed Data Types
- Variable Length Data Types
- Data Modification Internals
Database Internals
- Understanding Execution Plans
- Plan Generation & Caching
- Plan Reuse & Recompilations
- Physical Join Operators
- Plan Cache Pollution
Execution Plans
- Table Scan/Index Scan/Index Seek
- Clustered/Non-Clustered Index
- Bookmark Lookups
- Index Intersection
- Filtered Indexes
- Indexed Views
- Page Fragmentation/Page Splits
- Fill Factor
- Searchable Arguments
- Index Maintenance
Indexing
- Overview
- Working with Statistics
- Statistics Maintenance
Statistics
- Concurrency
- Pessimistic
- Optimistic
- Isolation Levels
- Viewing Locks / Lock Granularity / Lock Hierarchy / Lock Escalation / Lock Compatibility / Lock Manager Internals
- Dynamic Management Views
Troubleshooting Locking
- Detection / Avoidance / Troubleshooting
Dead Locking
- Architecture / Types / Modes / Hash Partitioning
Latches
- Performance Monitoring Methodology
- PAL/RML Utilities
- Wait Stats
- SQL Server Profiler & Perfmon
- OS & Storage Configuration
- Database Configuration
- Memory Management
- Parallelization
- TempDb
Dates: November 14th, 15th & 16th
Veune: Dublin – venue TBC
Cost: €1,799 (Early Bird until September 30th 2012 €1,500)
Nguồn: http://www.prodata.ie/events/2012/SQL-Performance_tuning_workshop.aspx
0 comments:
Post a Comment