When collecting Azure diagnostic data, an intermediate diagnostic data cell is also sent to the WadPerformanceCounters table?
Yes, they fall into the same table.
Each deployment receives its own unique deployment identifier, which can be found on the control panel for a specific instance (creation or step)

WadPerformanceCountersTable table example

To find the logs associated with a particular deployment (stage or production), you can filter the table by deployment ID, for example.
DeploymentId eq '1a2c09bea1234bc1b5e6edb99993ab21'
If you have too many records for one deployment identifier, you reduce the number of records by adding, say, a time attribute (all records with DeploymentId '1a2c09bea1234bc1b5e6edb99993ab21' were recorded after midnight January 5, 2013), for example
DeploymentId eq '1a2c09bea1234bc1b5e6edb99993ab21' and Timestamp gt datetime'2013-01-05T00:00:00Z'
Note that this is not a very optimal way to filter Azure Table Storage (as indicated by Qiwi and Gaurava.
Any query that will not include PartitionKey will result in a full table scan. Since the PartitionKey in WAD tables represents a date / time value, I would recommend using this instead of Timestamp . You can find an efficient way to extract diagnostic data . The post is very helpful.
This will help you find records for each environment (intermediate or production) and specific deployment.
Tom
source share