From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Identify performance issues using DMVs

Identify performance issues using DMVs

From the course: Microsoft Azure Database Administrator Associate (DP-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Identify performance issues using DMVs

“

- Welcome back, this is lesson 8.4. Identify Performance Issues Using Dynamic Management Views, or DMVs. Let's begin this discussion with a quick introduction to DMVs. These are built in, DMVs are built in, and we can include dynamic management functions here, and they're built in objects that can be used to monitor the health and performance of SQL. Using DMVs is a great way to detect problems and tune performance. All DMVs begin with the sys.dm, at least the ones we're going to be talking about in this video begin with sys.dm_. And their scope are at the server level and the database level. These DMVs return state information, meaning the information they return is internal implementation specific state data. So there's a lot of DMVs, but when trying to track down and identify performance issues, there are a few key DMVs that you should use. Now, what I'll talk here, or what I'll reference here is certainly not a complete list, but some DMVs that you should start with and I'll break…

Contents