Real World Sql Server Profiler

[LeeAndro]

Last updated 1/2017MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 146.44 MB | Duration: 1h 7m

Master the Fundamentals of SQL Server Profiler

What you'll 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.​

Requirements
You'll need to have SQL Server installed locally.
You'll need a copy of the Adventureworks learning database attached to that instance.
A familiarization with SQL Server would be helplful.
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 somes 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 Ee

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 ee.

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 , 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.

Overview

Section 1: An Introduction to SQL Server Profiler

Lecture 1 Course Introduction

Lecture 2 Profiler Architecture

Lecture 3 The Big 4 - The Terms We Need to Know

Lecture 4 Granting Users the Rights to Run Profiler

Lecture 5 The Profiler Toolbar

Lecture 6 Creating Our First Trace

Lecture 7 Save and Re-Open Trace File

Lecture 8 Summary

Section 2: Hands on Profiler: Traces and Templates

Lecture 9 Event Selection

Lecture 10 Adding a Database Filter

Lecture 11 Group Events

Lecture 12 Save Trace to Table

Lecture 13 Built-In Trace Templates

Lecture 14 Creating, Editing and Deleting Templates

Lecture 15 Create Custom Template From Existing Template

Lecture 16 Summary

Section 3: Real World Profiler

Lecture 17 Overload - Too Much Stuff

Lecture 18 Filters Don't Reduce Workload - Most of the

Lecture 19 Categories Are Suggestions

Lecture 20 Tip - Select or Deselect All Data Points

Lecture 21 Adding Multiple Filters

Lecture 22 Using Wildcard Searches

Lecture 23 The "Server Process Trace Data" Option

Lecture 24 Tip - Schedule a Trace and How to Disable Autoscroll

Lecture 25 Summary

Section 4: Find the Slow Runners

Lecture 26 What are we looking for

Lecture 27 What are we trying to capture

Lecture 28 Event Selection - The Big 4

Lecture 29 Setting Global Trace Options

Lecture 30 Post Analysis of the Capture

Lecture 31 Defining Our Data Columns

Lecture 32 Final Analysis

Lecture 33 Summary

If you are interested in learning how to use SQL Server Profiler then this course is for you.

HomePage:

Https://anonymz.com/https://www.udemy.com/course/real-world-sql-server-profiler/

DOWNLOAD

https://1dl.net/bmjutu73dwoe/P7DZzEfq__Real_World.rar.html