From the course: SQL Server 2022 Administration

Unlock this course with a free trial

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

Use performance monitor

Use performance monitor - SQL Server Tutorial

From the course: SQL Server 2022 Administration

Start my 1-month free trial Buy for my team

Use performance monitor

“

So if you've worked with Windows for a while or done any Windows Administration, you're probably familiar with the performance monitor tools that are built into the Windows system, specifically the Performance Monitor, which we're going to look at, because it can be utilized not only to watch Windows Resources, but also to look at SQL Server resources to get an idea of how things are operating inside your SQL Servers. So for this lesson, I'm actually going to fire up perf mon, which is the Performance Monitor. Okay. And up this comes. And again, if you've worked with Windows, you've probably at least been in here. And if I click on "Performance Monitor," I get this graph. And this is real time information showing me these counters that are configured down below. Now I can put in things that are pertinent to Windows. In this case, this is showing me my processor time. But alongside of Windows counters, you can also put SQL Server counters in here. Okay. So once you install SQL and…

Contents