Introduction to SQL Server Profiler- (SQL Server DBA Tool)

Introduction to SQL Server Profiler- (SQL Server DBA Tool), available at $39.99, has an average rating of 3.65, with 33 lectures, based on 22 reviews, and has 1267 subscribers.

You will learn about Build custom traces from scratch Save Profiler traces to File This course is ideal for individuals who are Beginner Database Administrator or Data Scientist or Beginner Big Data Analyst or Data Analyst or Analyst It is particularly useful for Beginner Database Administrator or Data Scientist or Beginner Big Data Analyst or Data Analyst or Analyst.

Enroll now: Introduction to SQL Server Profiler- (SQL Server DBA Tool)

Summary

Title: Introduction to SQL Server Profiler- (SQL Server DBA Tool)

Price: $39.99

Average Rating: 3.65

Number of Lectures: 33

Number of Published Lectures: 33

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 33

Original Price: $109.99

Quality Status: approved

Status: Live

What You Will Learn

Build custom traces from scratch
Save Profiler traces to File

Who Should Attend

Beginner Database Administrator
Data Scientist
Beginner Big Data Analyst
Data Analyst
Analyst

Target Audiences

Beginner Database Administrator
Data Scientist
Beginner Big Data Analyst
Data Analyst
Analyst

SQL Server Profiler is a powerful tool that allows you to capture and analyse events, such as the
execution of a stored procedure, occurring within SQL Server. This information can be used to identify
and troubleshoot many SQL Server-related problems.

if you are new to using Profiler, this introductory course is where you want to begin. In
this course , we’ll cover the basics of how Profiler works, its core terminology, and how to create and
save basic Profiler traces.

One of the things that separate mediocre DBAs from exceptional ones is that exceptional DBAs know how to use the tools available to them effectively.

The SQL Server Profiler can help DBA’S:
    • Monitor the activity of the:
    • SQL Server Database Engine
    • Analysis Services -SSAS
    • Integration Services -SSIS
    • Reporting Services -SSRS
    • Monitor and identify performance-related problems with front-end application, queries,T-SQL, transactions, and       much more
    • Monitor and identify SQL Server errors and warnings
    • Audit user activity
    • Analyse trace results by grouping or aggregating them
    • Create your own custom traces, and save them, for use whenever you wish

We will also cover profiler terminology like:
     • Events
     • Data columns
     • Filters
     •Trace

Also we will be working with traces and templates and learn:
• How to build custom traces from scratch
• How to Save Profiler traces to a SQL Server Table
• How to trace Analysis Services activity

After the end of this course , you will know why Profiler is such an essential tool in the DBA’s armoury, and will:

• Understand how Profiler works
• Be familiar with core Profiler terminology, such as events, data columns, filters and traces
• Understand the permissions required to use Profiler and how to start up Profiler
• Be able to create and control basic Profiler traces and then save a completed trace to a file.

Course Curriculum

Chapter 1: Setting up Your Test Environment

Lecture 1: Introduction

Lecture 2: What is SQL Server

Lecture 3: Hardware and Software Requirements

Lecture 4: Download SQL Server

Lecture 5: Install SQL Server

Lecture 6: Download and install AdventureworksDW2014

Lecture 7: Download Adventureworks 2014 Database

Lecture 8: Install Adventureworks2014 Database

Lecture 9: Install Multiple SQL Server Instance

Lecture 10: Connect to a named instance of SQL Server

Chapter 2: SQL Server 2019 Setup

Lecture 1: SQL Server Editions

Lecture 2: Hardware | Software Requirements

Lecture 3: Download SQL server

Lecture 4: Install SQL Server

Lecture 5: Install SSMS

Lecture 6: SQL Server Configuration Manager

Lecture 7: Connecting SSMS to SQL Server

Lecture 8: Install Sample Database

Chapter 3: Getting Started with SQL Server Profiler

Lecture 1: What is SQL Server Profiler ?

Lecture 2: How Profiler can make you a better DBA

Lecture 3: SQL Server Profiler Architecture

Lecture 4: SQL Server Terminology

Lecture 5: Permissions to access Profiler

Lecture 6: How to start SQL Server Profiler

Lecture 7: Stimulating Database activity

Lecture 8: How to start a Trace

Lecture 9: How to load a saved Trace

Lecture 10: Summary

Chapter 4: Working with Traces and Templates

Lecture 1: Exploring Events Selection

Lecture 2: Creating a custom trace from scratch – Part 1

Lecture 3: Creating a custom trace from scratch – Part 2

Lecture 4: Creating a custom trace from scratch – Part 3

Lecture 5: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 9 votes
4 stars: 6 votes
5 stars: 6 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu