Geek Answers Handbook

What are these tables created by diagnostics?

Azure Diagnostic creates many tables, apparently containing the same performance counters, but on different days. Why does he create so many tables and how can they be deleted?

enter image description here

+4
source share
1 answer

When you create an Azure application, you can enable or disable diagnostics in the role configuration file:

enter image description here

When diagnostics is turned on, all Verbose Monitoring data (logs) will be periodically copied to Azure tables (remember that in the production system you will have to specify the storage account separately, since it is not performed automatically).

For each cloud service deployment, six tables are created for this role. For each of them two tables are created: 5 minutes, 1 hour and 12 hours. One of these tables stores role-level aggregations; another table stores aggregates for role instances.

Table names have the following format:

WAD*deploymentID*PT*aggregation_interval*[R|RI]Table

Where:

  • deployID is the GUID assigned to deploy cloud services
  • aggregation_interval = 5M, 1H or 12H
  • role level aggregations = R
  • for role instances = RI

Examples:

  • WAD8b7c4233802442b494d0cc9eb9d8dd9fPT1HRTable - time clusters for the role
  • WAD8b7c4233802442b494d0cc9eb9d8dd9fPT1HRITable - hourly clusters for role instances
+4
source

More articles:


All Articles