SQL Server Performance

sys.dm_os_performance_counters , cntr_type = 1073874176

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by LanLan, Apr 18, 2008.

  1. LanLan New Member

    Anyone here knows how to interpret the counter type 1073874176 of sys.dm_os_performance_counters ? There is little document on this. I googled a lot, and only find one relevant article from Delaney. It only says 1073874176 is the counter needs base, but illustrates how to calculate assocating with its base value (1073939712) : division or minus?
  2. MohammedU New Member

    I believe it is Division...
  3. satya Moderator

    Now your post refers mostly on google [:)].
    As you may have seen this is Avg. Wait Time (Locks) which is a base value, also BOL references:
    The performance counter type designates a formula required to obtain calculated performance counters. These are the same counter types used by Windows Performance Monitoring. In WMI performance classes, the raw data for the counter type formula comes from a Win32_PerfRawData class and the calculated result is found in the same-named property of a corresponding Win32_PerfFormattedData class.
    Counter types appear as the CounterType qualifier for properties in Win32_PerfRawData classes, and as the CookingType qualifier for properties in Win32_PerfFormattedData classes.
    For example, the AvgDiskBytesPerRead property in the Win32_PerfRawData_PerfDisk_LogicalDisk class is the raw data source for the AvgDiskBytesPerRead property in the class Win32_PerfFormattedData_PerfDisk_LogicalDisk, which contains the same data as shown in System Monitor.

    The following list organizes

Share This Page