What Is DMV Collector In Azure SQL Database

by

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

  1. The first thing is, in the Master DB, you need to create a user.
  2. 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.

Wrapping Up

In this Azure SQL article, we discussed What Is DMV Collector In the Azure SQL Database. Thanks for reading this article !!!