SQL Server 2012 Performance Tuning
Description
The SQL Server 2012: Performance Tuning - Design, Internals, & Architecture berdurasi 4 hari training membahas lebih jauh tentang aspek SQL Server yang mempengaruhi Application performance. Mempelajari tentang SQL Server Engine seperti Memory Manager dan Task Scheduler, Table dan Index Structure, Locking dan Concurency , Query Optimization dan Programming Efficiency.
Goals
Peserta mampu memahami cara memaksimalkan kinerja SQL Server dari berbagai aspek dan fitur yang ada di SQL Server
Participants
- Database Developer
- System Developer
- DBA
Prerequisites
SQL Server DBA fundamental
Details
Day 1: Architecture
This lesson provides an overview of SQL Server engine internals such as
memory management, I/O basics, process scheduling and synchronization with
particular focus on performance tuning.
Day 2: Table & Index Structure
This lesson takes an in-depth look into the underlying structure of database
files, tables and indexes and how they affect performance. Students will come
away with the knowledge they need to design databases and implement efficient
indexing strategies.
Day 3: Locking & Concurrency
This lesson looks into how SQL Server handles concurrency behind-the-scenes.
Students will learn the basic concepts of locking, the various isolation levels
of SQL Server, how different isolation levels affect concurrency, and the
effects of concurrency issues – as well as how to identify and resolve them.
Day 4: Query Optimization
This lesson provides in-depth information for understanding the end results
of query optimization and execution plan creation in SQL Server 2012. Students
will learn how to understand query plans and identify queries that
Duration : 4 Days (24 hours)
|
|
