Introduction to SQL Server Profiler- (SQL Server DBA Tool)
3.2 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,192 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Introduction to SQL Server Profiler- (SQL Server DBA Tool) to your Wishlist.

Add to Wishlist

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

Learn to use SQL Server Profiler to capture and analyse SQL Server events
3.2 (3 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,192 students enrolled
Last updated 4/2017
English
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Build custom traces from scratch
  • Save Profiler traces to File
View Curriculum
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 is the target audience?
  • Beginner Database Administrator
  • Data Scientist
  • Beginner Big Data Analyst
  • Data Analyst
  • Analyst
Students Who Viewed This Course Also Viewed
Curriculum For This Course
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
About the Instructor
Bluelime Learning Solutions
4.1 Average rating
1,739 Reviews
38,665 Students
91 Courses
Learning made simple

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .

Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.