Post reply

Data Collector Network Usage Report

  • February 9, 2012 at 10:18 am

    #252699

    Does anyone know how the Network Usage report under Server Activity History in the Data Collector is generated?

    I'd like to try to get more detail on the network utilization. The report is not a drill down. I can't figure out where the network data is stored in the warehouse database.

    Thanks

  • February 9, 2012 at 11:38 am

    #1445223

    You'll need to join the snapshots.performance_counter_instances.performance_counter_instance_id to snapshots.performance_counter_values.performance_counter_instance_id.

    The performance_counter_instances table contains a list of the counters, search for the object_name of "Network Interface" and choose the relevant counter you want to look at.


    Shamless self promotion - read my blog http://sirsql.net

  • February 9, 2012 at 1:08 pm

    #1445258

    Thank you!!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply