Well, here we will discuss DMV collector in the Azure SQL database. DMV is nothing but Dynamic Management Views.
What Is DMV Collector In Azure SQL Database
Dynamic Management Views is responsible for providing you the information about the server state which can help you to easily monitor the server’s health and help you to easily diagnose the problems of the server, Based on the server information, you can easily tune the performance of the server.
Basically, Dynamic Management Views and functions are categorized into two main types. Those are as below
- Server-scoped dynamic management views: You need to provide the VIEW SERVER STATE permission on the server in case of Server-scoped dynamic management views.
- Database-scoped dynamic management views: You need to provide the VIEW DATABASE STATE permission on the database in the case of Database-scoped dynamic management views.
You can refer to the Dynamic Management Views in Transact-SQL with the help of two-part, three-part, or four-part names.
An important point to note here is, that you must need the SELECT permission on the object and the VIEW DATABASE STATE permission or the VIEW SERVER STATE permission to query the Dynamic Management Views.
This permission actually helps you to restrict the user from accessing the dynamic management views.
The complete process for this restriction functionality is as below
- The first thing is, in the Master DB, you need to create a user.
- As a second step, on the dynamic management views, you need to deny the user SELECT permission.
Now, it will not allow the select operation from these dynamic management views.
In this Azure SQL article, we discussed What Is DMV Collector In the Azure SQL Database. Thanks for reading this article !!!
I am Rajkishore, and I have over 14 years of experience in Microsoft Azure and AWS, with good experience in Azure Functions, Storage, Virtual Machine, Logic Apps, PowerShell Commands, CLI Commands, Machine Learning, AI, Azure Cognitive Services, DevOps, etc. Not only that, I do have good real-time experience in designing and developing cloud-native data integrations on Azure or AWS, etc. I hope you will learn from these practical Azure tutorials. Read more.