Real World SQL Server Profiler

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 Profileris a graphical user interface to SQL Trace for monitoring T-SQL Statements of Database Engine

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

This informationcan 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 toolsavailable 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 architectureof 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, replayand 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 datawhen it’s not filtered and lastly it can consume a lot of resourceson 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 profileris 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.�

Rating Distribution

• 1 stars: 0 votes
• 2 stars: 3 votes
• 3 stars: 9 votes
• 4 stars: 20 votes
• 5 stars: 36 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!