What is a dynamic management view?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a dynamic management view?
Rating:
A dynamic management view returns information about the state of SQL Server. This information is used to monitor and identify issues that occur in SQL Server and to enhance performance. There are two types of dynamic management views:
- The server-scoped dynamic management view: This view requires the VIEW SERVER STATE permission on the server.
- The database-scoped dynamic management view: This view requires the VIEW DATABASE STATE permission on the database.
Rating:
Was this information helpful?
Other articles
- What is a default instance?
- What is a format file?
- What is a queue?
- What is a partition scheme?
- What is a constraint?