Home   Schulung > EDV > Backoffice > SQL Server

This course is oriented towards advanced concepts of diagnostics, query refactoring and performance scalability, I/O optimization and their implementation to the production environments. It also covers unusual optimization strategies by utilizing most of the SQL Server components. The most of this course is also applicable for SQL Server 2005 users, as they share the same architecture. Upon successful completion of this course, students will be able to: - Diagnose performance problems at the server and query level - Avoid the biggest SQL Server performance killers - Design and refactor queries correctly - Solve problems with locking, transactions and deadlocks - Detect and solve problems with tempdb - Detect and solve problems with indexes and recompilations - Optimize I/O performance - Scale out overall performance of databases - Normalize the databases during operations - Take advantage of parallel processing - Use advanced optimization techniques by leveraging SQL Server components

Microsoft SQL Server 2008/R2 Advanced Performance Tuning

Ziel
This course is oriented towards advanced concepts of diagnostics, query refactoring and performance scalability, I/O optimization and their implementation to the production environments. It also covers unusual optimization strategies by utilizing most of the SQL Server components. The most of this course is also applicable for SQL Server 2005 users, as they share the same architecture.Upon successful completion of this course, students will be able to:- Diagnose performance problems at the server and query level- Avoid the biggest SQL Server performance killers- Design and refactor queries correctly- Solve problems with locking, transactions and deadlocks- Detect and solve problems with tempdb- Detect and solve problems with indexes and recompilations- Optimize I/O performance- Scale out overall performance of databases- Normalize the databases during operations- Take advantage of parallel processing- Use advanced optimization techniques by leveraging SQL Server components
Schulungsinhalte


· Diagnostics
Methodology of performance tuning . Diagnostics using DMV . Recording workload using SQL Profiler . Automating the processing of diagnostics data . Setting performance baseline for long-term system monitoring .Best optimization approach

· Refactoring Queries
SQL Server Performance Killers . Recommendations for correct design of queries and refactoring of existing queries . Recompilation of stored procedures and ad-hoc queries, its detection and removal . Replacement of temp tables in the queries by table variables . Solving problems with indexes and statistics . Hints for indexes . Locking, blocking and hints . Transactions and their optimization . Deadlock analysis and removal . Replacing lengthy SQL analyses by fast OLAP analyses

· Optimization of I/O
Increasing I/O performance by adding data files . Partitioning the data and indexes, partition switching . Optimization of transaction logs . Optimizing the performance of tempdb . Detecting tempdb utilization by queries, its causes and elimination . SSDs - yes or no? . Additional options for optimizing I/O performance

· Scaling Out
Implementation of load balancing for R / O operations . Implementation of load balancing for the R / W operations . Speeding up reporting against given point in time (snapshots) . Normalization of the database during operations . Parallelization and de-parallelization of queries . Introduction to SQL Server 2008 R2 Parallel Data Warehouse edition . Massively parallel in-flight processing of events using StreamInsight

· Other Optimization Techniques
Optimization of data transfers into the data warehouses (CDC / CT + SSIS) . Optimization of asynchronous processing using queues and Service Broker . Optimization of XML processing, geographic, and hierarchical data . Optimization of backup and restore speed . SQL Server optimization checklist . New performance enhancements in SQL Server 2012 .
Zielgruppe
This course is intended for experienced administrators and developers, who already know the fundamentals of SQL Server optimization, but need to know and apply advanced techniques to get much more performance out of their SQL Server infrastructure.
Voraussetzungen
The knowledge of performance tuning at the level of course „SQL Server 2008/R2 Performance Tuning Fundamentals” or equivalent is necessary for this course.
Ausschließlich als Inhouse-Schulung
Dieses Seminar bieten wir ausschließlich als Inhouse-Seminar in Ihren Räumlichkeiten oder bei uns in Münster an.
Seminardaten
Schulung-Nrsql08apt
Dauer3 Tage
Inhouse-Schulung
Dieses Seminar bieten wir Ihnen als Inhouse-Seminar oder -coaching vor Ort in Ihren Räumlichkeiten an.

Rufen Sie uns bitte an:

+4925198 110 99 0
QRCode zu dieser Schulung

Aktuelle Termine
Garantierte Durchführung Garantierte Durchführung!