Collect Performance and System Information

Practice Labs Module
Time
30 minutes
Difficulty
Intermediate

The "Collect Performance and System Information" 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) Collect Performance Information using Dynamic Management Views and SQL Server Profiler.

Start your free 3-day trial and become one of the 3 million Cybersecurity professionals advancing their career goals
Sign up with
OR

Already have an account? Sign In »

Overview

Introduction

The Collect Performance and System Information 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. Collect Performance Information using Dynamic Management Views and SQL Server Profiler

Exercise 1- Collect Performance Information using Dynamic Management Views and SQL Server Profiler

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

  • Use dynamic management views to determine performance issues
  • Work with SQL Server profiler for identifying and troubleshooting performance issues
Delivered By
Comprehensive Learning

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