Type and hit enter to Search
×

Sql Server 2016 Admin High Availability and Performance Tuning

  • 4.9(2,443 Rating)

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.

Multiple Routes of Delivery to
Fit Your Timetable

We understand that flexibility is key to effective learning and development, especially in today’s dynamic work environment. That’s why we offer multiple delivery formats for our IT trainings in UAE. Whether you prefer the interaction of in-person classes, the convenience of live virtual training, or the independence of self-paced online learning, we have a solution tailored to your schedule. Our goal is to make professional growth accessible to everyone, allowing you to upskill without compromising your other commitments.

Schedule Dates

16 December 2024 - 20 December 2024
Sql Server 2016 Admin High Availability and Performance Tuning
17 March 2025 - 21 March 2025
Sql Server 2016 Admin High Availability and Performance Tuning
23 June 2025 - 27 June 2025
Sql Server 2016 Admin High Availability and Performance Tuning
29 September 2025 - 03 October 2025
Sql Server 2016 Admin High Availability and Performance Tuning

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.

Open chat
Hello
How Can We Help You?