High Availability is a broad term used and misused throughout online and offline discussions about up-time and application availability. For the DBA, it is critical to understand this topic and the technological underpinnings of the high availability options Microsoft provides within SQL Server. This course will begin by explaining key terms and concepts surrounding the idea of high availability. Following that, every SQL Server high availability option will be discussed and demoed and, by the end of course, students will have a firm idea of what high availability tools are presented within SQL Server as well as how to deploy those tools.
Overview
COURSE DIFFICULTY
COURSE DURATION
3h 18m
Skills Learned
After completing this online training course, students will be able to:
Write T-SQL queries for data retrieval and manipulation
Optimize query and server performance
Database Administrators
None
01. SQL Server Performance Tuning - What you need to get started
02. Class Introduction
03. Understanding Queries in SQL Server (Query Basics)
04. Understanding Queries in SQL Server(Relational Engine Query Process)
05. Understanding Queries in SQL Server (Parallelism)
06. Index Tuning (Basic Tuning)
07. Index Tuning (Columnstore Indexes and Maintenance)
08. Locking, Blocking, Deadlocks and Latches
09. Waits and Queues Methodology
10. Baselines
11. Monitoring and Alerting
12. Extended Events
SKILLS LEARNED
Skills Learned
After completing this online training course, students will be able to:
Write T-SQL queries for data retrieval and manipulation
Optimize query and server performance
WHO SHOULD ATTEND
Database Administrators
PREREQUISITES
None
COURSE OUTLINE
01. SQL Server Performance Tuning - What you need to get started
02. Class Introduction
03. Understanding Queries in SQL Server (Query Basics)
04. Understanding Queries in SQL Server(Relational Engine Query Process)
05. Understanding Queries in SQL Server (Parallelism)
06. Index Tuning (Basic Tuning)
07. Index Tuning (Columnstore Indexes and Maintenance)
08. Locking, Blocking, Deadlocks and Latches
09. Waits and Queues Methodology
10. Baselines
11. Monitoring and Alerting
12. Extended Events
