From the course: SQL Server 2022 Administration

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Use the performance and reliability monitoring tools

Use the performance and reliability monitoring tools - SQL Server Tutorial

From the course: SQL Server 2022 Administration

Start my 1-month free trial Buy for my team

Use the performance and reliability monitoring tools

“

So the first tool I want to take a look at in this lesson is the SQL Server Profiler. The SQL Server Profiler is a tool that, again, is installed with the SQL Server Microsoft Management Tools, and it allows you to profile queries on your system to see how they're performing. It's a fairly simplistic looking tool. As you can see I have it open here, but what we'll do is we'll hit the "New" button and this will pop up and ask me to set up a trace template. So what is it that I'm trying to analyze? So for server type here, I'll click this dropdown and you'll see I have all kinds of options of the different kinds of SQL Server I want to analyze. I'm going to go ahead and say Microsoft SQL Server 2019 because that's the latest available in this particular release of the toolset. And that's fine. And then I could pick a template or I could make a new template name and we'll just call this Inside Out Trace. And the important part of this is what do you do in this event selection? So what is…

Contents