locked
Two Rowkey for one performance counter in WADMetrics tables in storage RRS feed

  • Question

  • After enabling diagnostic setting for ARM VM, performance data will be stored in WADMetrics of table storage. I refered this link to check the entity in the table.

    https://docs.microsoft.com/en-us/azure/virtual-machines/virtual-machines-windows-extensions-diagnostics-template 

    But I found there will be two entity to record one performance counter. The only difference is the rowkey which the order of time and countername was upsidedown. For example:


    RowKey

    Timestamp

    Average

    Count

    CounterName

    Last

    Maximum

    Minimum

    TIMESTAMP

    Total

    2519140211999999999__:005CNetworkInterface:005CBytesReceived

    2017-02-28T12:00:05.779Z

    107553707

    240

    \NetworkInterface\BytesReceived

    112956571

    112956571

    102168249

    2017-02-28T11:00:00.000Z

    25812889756










    :005CNetworkInterface:005CBytesReceived__2519140211999999999

    2017-02-28T12:00:05.779Z

    107553707

    240

    \NetworkInterface\BytesReceived

    112956571

    112956571

    102168249

    2017-02-28T11:00:00.000Z

    25812889756

     Anyone know why we need two entity for one performance counter? 
    • Moved by Loydon Mendonca Wednesday, March 1, 2017 4:48 PM Moving to Azure Storage
    Wednesday, March 1, 2017 5:11 AM

Answers

  • To clarify: Is the rowkey is a string that is picked by the client that is putting the value in?

     

    Here the timestamp as the prefix and the other has the counter name as the prefix.
    The "viewer" (application insights) needs to fetch by both parameters, so they are increasing performance at the cost of space usage.

    • Marked as answer by Lickky Tuesday, March 7, 2017 1:51 AM
    Thursday, March 2, 2017 3:15 PM

All replies

  • To clarify: Is the rowkey is a string that is picked by the client that is putting the value in?

     

    Here the timestamp as the prefix and the other has the counter name as the prefix.
    The "viewer" (application insights) needs to fetch by both parameters, so they are increasing performance at the cost of space usage.

    • Marked as answer by Lickky Tuesday, March 7, 2017 1:51 AM
    Thursday, March 2, 2017 3:15 PM
  • To clarify: Is the rowkey is a string that is picked by the client that is putting the value in?

    ==> Yes, the rowkey is generated at client when it uploads the record to storage account. 

    I understand your comments about the performance and cost consideration, but since this behavior is not match with what the Azure documents, should the doc be updated to reflect this? 

    https://docs.microsoft.com/en-us/azure/virtual-machines/virtual-machines-windows-extensions-diagnostics-template 

    And what's more, where can we have a introduction of the columns like count, total ? 

    Thanks. 

    Tuesday, March 7, 2017 1:51 AM