Sql Server 2016 Admin High Availability and Performance Tuning

Overview Schedule Dates Course Content Faqs

Course Overview

The SQL Server 2016 Admin High Availability and Performance Tuning course from Microsoft is designed to equip IT professionals with the essential skills to manage and optimize SQL Server 2016 environments effectively. This comprehensive training delves into advanced strategies for ensuring high availability, crucial for maintaining uninterrupted database operations. Participants will explore various high availability solutions, including Always On Availability Groups and Failover Clustering, to ensure resilience and reliability.

In addition to high availability, the course provides in-depth coverage of performance tuning techniques to enhance the efficiency of SQL Server instances. Learners will gain practical knowledge on identifying performance bottlenecks, optimizing queries, and utilizing SQL Server’s built-in tools for monitoring and troubleshooting performance issues. By the end of the course, participants will be adept at implementing best practices for high availability and performance tuning, ensuring that their SQL Server environments are robust, efficient, and capable of meeting the demands of modern data management.

Learning Options

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

Schedule Dates

Sql Server 2016 Admin High Availability and Performance Tuning

16 December 2024 - 20 December 2024

Sql Server 2016 Admin High Availability and Performance Tuning

16 March 2025 - 20 March 2025

Sql Server 2016 Admin High Availability and Performance Tuning

16 June 2025 - 20 June 2025

Sql Server 2016 Admin High Availability and Performance Tuning

22 September 2025 - 26 September 2025

Course Content

Assigning Server and Database Roles
Authorizing Users to Access Resources
Automating SQL Server management
Tracing Access to SQL Server with Extended Events

Merge Replication and Merge Agent Job
Replication Conflicts and ROWGUIDCOL
Peer-Peer Replication Connections, Nodes
Common Errors and Solutions

Log Shipping Topology for HA and DR
Primary and Secondary: Recovery Plan
Log Shipping Monitor, Jobs and Alerts
Re-Restoring Log Backups for Recover
Broken Log Shipping Chains & Issues
Common Errors and Solutions

DB Mirroring Architecture For HA & DR
Log Shipping Versus Database Mirroring
Automatic Fail-Over Procedures, Tests
PARTNER OFFLINE Conditions, Options
DB Mirroring Monitors and Commit Loads
Mirroring Monitor Jobs
Common Errors and Solutions

Windows Clusters for HA and DR
Domain Controller (DC) Configuration
Active Directory (AD) Accounts, Use
Windows Level Clusters, MSCS Service
SQL Cluster Groups, Domain Accounts
Need for Always - On Availability (AAG)

Always On Availability Group [AOAG]
Synchronous and Asynchronous Modes
Facets and Conditions for Policies
Synchronization, Automated Seeding
Port Settings, Backup Strategies in AAG
Adding Availability Listeners and DNS
Always-On Availability Groups Health

Tuning Tools : Workload Files, Trace Files
Profiler Tuning Template, SP Events
Perfmon Tool Counters, Real-time Tracking
Execution Plan Analysis and Internals
Query Costs: SubTree & Operator Cost
LOCKS : Types and Isolation Levels
Lock Audits : SP_WHO2 and SP_LOCK
S, X, IX,U, MD, Sch-M and Sch-S
XDL Files and Deadlocks Prevention
Deadlock Audits and Deadlock Graphs

Advantages, Performance
Working with Indexes and Partitions
Internal and External Fragmentation
Index Rebuilding Process and Audits
Database Maintenance Plans Jobs
Last Used, Page Count, Fragmentation
Index Page Count and Index Condition
Degree Of Parallelism [DOP] Settings
PAUSE & RESUME in Index Rebuilds

FAQs

The course offered by CounselTrain provides comprehensive training on maintaining the high availability and performance of SQL Server 2016 databases. It covers key topics such as security models, backup and recovery, automation, performance tuning, and high availability solutions.

Basic knowledge of SQL Server and experience with database administration is recommended. Familiarity with SQL Server 2016 or previous versions will be beneficial for understanding the course content.

The course is structured into modules, each focusing on different aspects of SQL Server 2016 administration. It combines theoretical knowledge with practical exercises and real-world scenarios.

CounselTrain offers support through instructors, a community forum for peer interaction, and customer support for any technical or course-related inquiries.