Introduction to SQL Server Profiler- (SQL Server DBA Tool)
3.9 (10 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,215 students enrolled

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

Learn to use SQL Server Profiler to capture and analyse SQL Server events
3.9 (10 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1,215 students enrolled
Last updated 4/2017
English
English [Auto-generated]
Current price: $11.99 Original price: $124.99 Discount: 90% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Build custom traces from scratch
  • Save Profiler traces to File

Course content
Expand all 24 lectures 02:08:11
+ Setting up Your Test Environment
10 lectures 50:12
Download SQL Server
04:07
Install SQL Server
06:47
Download and install AdventureworksDW2014
06:39
Download Adventureworks 2014 Database
05:06
Install Adventureworks2014 Database
04:14
Install Multiple SQL Server Instance
09:25
Connect to a named instance of SQL Server
03:44
+ Getting Started with SQL Server Profiler
10 lectures 46:52
What is SQL Server Profiler ?
01:45
How Profiler can make you a better DBA
03:27
SQL Server Profiler Architecture
06:09
SQL Server Terminology
08:05
Permissions to access Profiler
06:34
How to start SQL Server Profiler
02:36
Stimulating Database activity
05:57
How to start a Trace
08:37
How to load a saved Trace
02:21
Summary
01:21
+ Working with Traces and Templates
4 lectures 31:07
Exploring Events Selection
09:31
Creating a custom trace from scratch - Part 1
12:34
Creating a custom trace from scratch - Part 2
04:31
Creating a custom trace from scratch - Part 3
04:31
Requirements
  • You should have basic knowledge of database concepts like "Table," "columns," and "Rows"
  • You should be able to use SQL Server Management studio ( SSMS) at a beginner level
Description

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.


Who this course is for:
  • Beginner Database Administrator
  • Data Scientist
  • Beginner Big Data Analyst
  • Data Analyst
  • Analyst