Real World SQL Server Profiler

Master the Fundamentals of SQL Server Profiler

4.55 (67 reviews)
Udemy
platform
English
language
Data & Analytics
category
instructor
Real World SQL Server Profiler
430
students
1 hour
content
Jan 2017
last update
$59.99
regular price

What you will learn

At the end of this course you'll have a very solid understanding of how to use SQL Server Profiler in the real world.

Description

Recent Review from Similar Course

"This was my first dba course. The course flowed well and the instructor seemed confident in his knowledge. Instructor stayed on topic and didn't get sidetracked by going down 'rabbit trails' of additional content, which can sometimes happen. I would definitely take another class with the same instructor."  Phil Carpenter 

Microsoft SQL Server Profiler is a graphical user interface to SQL Trace for monitoring T-SQL Statements of Database Engine

SQL Server Profiler is a powerful tool that allows you to capture and analyze events.

This information can be used to identify and troubleshoot many SQL Server-related problems.

One of the things that separate less knowledgeable DBAs from exceptional ones is that exceptional DBAs know how to take full advantage of the tools available to them.

Even though Profiler can be used to monitor analysis services and integration services its core use is for tracking down real world issue that happen within SQL Server’s database engine.

In this course, we are going to cover the architecture of SQL Server Profiler and then use it to track down performance related issues.

In the course, we are also going to cover the nomenclature in detail. What’s an event and for that matter what’s an event class? How do I use them?

The interface isn’t that intuitive and in this course we will walk through all the tabs and their meaning as well as learn how to use them to capture only what we want to see, not the thousands of lines we don’t need.

With profiler, we can: create traces, watch the trace capture the spids in real time, store it, replay and even save the output to a server to others can view the results in table format.

There are several reasons profiler isn’t used more often in the real world. Firstly, the interface isn’t well designed, secondly it creates a ton of data when it’s not filtered and lastly it can consume a lot of resources on the server.

If the profiler is configured appropriately to trace only relevant data for analysis, it will diminish the additional load that is introduced while it is running.

If profiler is run for a longer duration, then to capture the event of longer duration it is very important to collect selective data, otherwise the collected data can outgrow the space on the server.

In this course, we are going to learn how to ameliorate all the “issues” with the tool and learn how to use it effectively in the real world.

Thanks for your interest in Real World SQL Server Profiler. 

Content

An Introduction to SQL Server Profiler

Course Introduction
Profiler Architecture
The Big 4 - The Terms We Need to Know
Granting Users the Rights to Run Profiler
The Profiler Toolbar
Creating Our First Trace
Save and Re-Open Trace File
Summary
Quiz

Hands on Profiler: Traces and Templates

Event Selection
Adding a Database Filter
Group Events
Save Trace to Table
Built-In Trace Templates
Creating, Editing and Deleting Templates
Create Custom Template From Existing Template
Summary
Quiz

Real World Profiler

Overload - Too Much Stuff
Filters Don't Reduce Workload - Most of the Time
Categories Are Suggestions
Tip Time - Select or Deselect All Data Points
Adding Multiple Filters
Using Wildcard Searches
The "Server Process Trace Data" Option
Tip Time - Schedule a Trace and How to Disable Autoscroll
Summary
Quiz

Find the Slow Runners

What are we looking for?
What are we trying to capture?
Event Selection - The Big 4
Setting Global Trace Options
Post Analysis of the Capture
Defining Our Data Columns
Final Analysis
Summary
Quiz

Reviews

Michael
June 7, 2022
Solid overview of SQL Server Profiler, great foundational course to become an expert at using this tool.
DMS
January 19, 2021
- English subtitles are often wrong, eg. "SQL" or "sequel" is "sical" in the most cases. It's hard with specific, unknown words, if somenone is not familiar with the topic - The Course itself gives an great overview of the topic
Apkambledev
March 19, 2020
Mike does a pretty good job of explaining how to use the tool. Looking forward to doing his other courses.
Pradeep
October 4, 2019
This course has precisely provided information , that I was looking from SQL profiler perspective. Although, I would appreciate if SP tuning can be amended as an additional section to current course.
Nick
June 29, 2018
Good to see niche topics that explain basic usage quickly without too much fluff. This course covers the bases without and is just the right length. Good instructor, experienced and accurate. Speed of the course was relaxed and easy to follow. I will be getting more courses from Mike for sure!

Charts

Price

Real World SQL Server Profiler - Price chart

Rating

Real World SQL Server Profiler - Ratings chart

Enrollment distribution

Real World SQL Server Profiler - Distribution chart

Related Topics

1066796
udemy ID
1/8/2017
course created date
11/20/2019
course indexed date
Bot
course submited by