Identify AzureDiagnostics Usage

Occasional Contributor

Hi,

 

Running the following to get usage info on the AzureDiagnostics table:

"AzureDiagnostics | summarize totalNumberofRecords = count() by ResourceId | sort by totalNumberofRecords desc"

 

ResourceID totalNumberofRecords

/SUBSCRIPTIONS/<Subscript ID>/RESOURCEGROUPS/<Resource Group>/PROVIDERS/MICROSOFT.SQL/SERVERS/<SQL Server VM>/DATABASES/MASTER                              14,078,942

 

Can someone clarify the "MASTER" entity at the end of the Resource ID? I'm trying to identify the resource and to check the diagnostic setting as this resource is using a large portion of the table.

 

Is this a reference to the Master DB within MS SQL Server DB?

 

I can't seems to identify it via the Azure Portal.

 

 

Many thanks.

 

J

0 Replies