Menu Icon

Courses & certifications

Home > Microsoft Training > SQL Server Training > SQL Server Performance Tuning and Optimization (M55144)

SQL Server Performance Tuning and Optimization (M55144)

In this course, you will learn practical tuning and optimization techniques for SQL Server 2014 that include indexing and statistics strategies, transaction log operations, tempdb and data file configuration, transaction and isolation levels, locking and blocking, and the new In-Memory OLTP engine. You will learn how to create baselines and benchmark SQL Server performance as well as analyze and fix workload for performance issues. This course incorporates materials from the Official Microsoft Learning Product 55144: SQL Server Performance Tuning and Optimization. Skills Gained

  • Skills Gained
  • Prerequisites
  • Who Can Benefit
  • Syllabus

In this course, you gain extensive experience using SQL Server 2012 "Always On" technologies to build a variety of high availability solutions.

You learn to install SQL Server on a cluster, set up log shipping, implement database mirroring and use replication as a high availability method.

You Will Learn How To:

  • Leverage SQL Server technologies to achieve high-availability solutions
  • Design a Service Level Agreement that matches business requirements
  • Plan, prepare and install a SQL Server failover cluster
  • Mirror a database to ensure instant failover
  • Automate deployment with Always On technologies
  • Ensure business continuity through failover clusters
  • Course participants creating a SQL Server failover cluster.

Hands-On Experience Includes:

  • Identifying availability requirements
  • Installing a SQL Server failover cluster
  • Backing up and restoring databases with advanced features
  • Maintaining a warm standby server
  • Mirroring the BizRoll database
  • Integrating high-availability techniques
  • Should have experience with database administration, along with a working knowledge of Windows Server.
  • Should know how to backup and recover databases, and manage SQL Server security.
  • Database administrators
  • IT managers
  • Network administrators
  • Anyone involved in planning, supporting or implementing a high-availability solution with SQL Server

High-Availability Fundamentals

Characterizing high availability

  • The "five nines"
  • Site
  • Instance
  • Database
  • Defining a Service Level Agreement

Planned vs. unplanned downtime

  • Performing routine maintenance
  • Recovering from disasters
  • Handling hardware failures

Installing Windows 2008 Fail over Clustering

Defining components of a cluster

  • Single instance architecture
  • Multi-instance architecture
  • Shared storage
  • Resource group
  • Heartbeat
  • Quorum

Preparing for Windows fail over clustering

  • Configuring an iSCSI target
  • Managing shared storage
  • Installing the fail over clustering feature

Establishing SQL Server Fail over Clustering

Planning for SQL Server fail over clustering

  • Upgrading from Windows Server 2003 to 2008
  • Migrating to SQL Server 2008
  • Leveraging virtual machines for clustering

Creating a SQL Server fail over cluster

  • Installing a new fail over cluster
  • Adding a new node
  • Failing over to a passive node

Employing Log Shipping

Preparing for a warm standby server

  • Synchronizing logins
  • Creating network shares

Implementing transaction log shipping

  • Specifying log backup frequency
  • Configuring the log shipping monitor

Switching to the standby server

  • Redirecting applications
  • Bringing the standby online

Configuring Database Mirroring

Comparing mirroring architectures

  • High availability
  • High protection
  • High performance
  • Full safety vs. safety off

Getting ready for mirroring

  • Setting the recovery model
  • Selecting the principal, mirror and witness servers

Mirroring a database

  • Configuring the principal, mirror and witness
  • Initiating the mirroring session

Administering mirroring

  • Enabling and disabling mirroring with scripts
  • Launching the Database Mirroring Monitor (DMM)

Employing a mirror for reporting

  • Taking a database snapshot
  • Querying a snapshot of the mirror

Always On Availability Groups

Enhancing the capabilities of database mirroring

  • Database mirroring with multiple databases and multiple mirrors
  • Manually failing over a group of databases

Clustering and deployment

  • Multi-site clustering across subnets
  • Automating deployment using Always On Power Shell cmdlets
  • Monitoring the high-availability configuration using the Always On dashboard

Combining High-Availability Technologies

Selecting the appropriate strategies

  • Determining the pros and cons of each HA technology
  • Failover clustering with a mirror

Pulling it all together

  • Creating a complete high-availability solution
  • Evaluating the results
  • Course Code: M55144
  • Duration : 5 Days
  • Certified by: Microsoft

RPS Travel & Stay

Worried about travel and Stay to our centers?

We can take care of that Find out more
Enquiry Image

India: +91 9148592716

International: +91 9883305050

Frequently Asked Questions


Students Certified


Keep me Updated

Get tips, latest Courses and Offers