TroubleShoot and Resolve Performance Problems

Practice Labs Module
Time
50 minutes
Difficulty
Intermediate

The "Troubleshoot and Resolve performance problems" module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: 1) Manage Large MDF and LDF Files, 2) Demonstrate Troubleshooting Replication, 3) Troubleshoot Data Access Problems.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or
Sign up with Google
Sign up with Apple
Sign up with Microsoft
View all SSO options

Already have an account? Sign In »

Overview

Introduction

The Troubleshoot and Resolve performance problems module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises:

  1. Manage Large MDF and LDF Files

  2. Demonstrate Troubleshooting Replication

  3. Troubleshoot Data Access Problems

Exercise 1- Manage Large MDF and LDF Files

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

  • Shrinking files to manage large MDF and LDF file size

Exercise 2 – Demonstrate Troubleshooting Replication

In this exercise, you will use Replication Agents tool to monitor replication problems. As a prerequisite to this task, you will first create transactional publication.

Exercise 3 – Troubleshoot Data Access Problems

In this exercise you will perform the tasks required to troubleshoot data access problem for a database user.

Learning Partner
Practice Labs

IT & Cybersecurity certification hands on practice labs and practice exams for certifications and skill development.

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.

Courses