From the course: Microsoft SQL Server 2022 Essential Training
Join today to access over 25,300 courses taught by industry experts.
Dynamic management views - SQL Server Tutorial
From the course: Microsoft SQL Server 2022 Essential Training
Dynamic management views
- [Instructor] Dynamic management views, or DMVs, return information about the state or the settings of your SQL Server instances. This information is useful for diagnosing problems and tuning performance. Just like other views on your database Dynamic Management Views combine columns and data from the internal system tables stored in the master database and display it in easy to access configurations. Dynamic Management Views come in two scopes: server and database. Server scoped DMVs will require VIEW SERVER STATE permission on the server in order to execute them. Database scoped DMVs require VIEW DATABASE STATE permission. So in order to view their contents users must have the appropriate permissions granted to them. Once you have the required permission level, running a dynamic management view is just like running any other view that you may create on your own data. You'll select individual columns from the view to…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.