Skip to content

sys.dm_os_performance_counters Revisited

November 17, 2010

It has been a while since I last blogged this subject, but today I found one particular item that needs amending. For cntr_type 1073874176 (cumulative ratio) I found several counters that don’t fit the “add ‘Base’ to the counter name” rule. They are:

Counter Object Counter Name Counter Base
SQLServer:Broker TO Statistics Avg. Length of Batched Writes Avg. Length of Batched Writes BS
SQLServer:Broker TO Statistics Avg. Time Between Batches (ms) Avg. Time Between Batches Base
SQLServer:Broker TO Statistics Avg. Time to Write Batch (ms) Avg. Time to Write Batch Base
SQLServer:Latches Average Latch Wait Time (ms) Average Latch Wait Time Base
SQL Server:Locks Average Wait Time (ms) Average Wait Time Base

I’m not kidding about the first one. Using “BS” instead of “Base” seems oddly self-descriptive of Microsoft’s naming rules and counter type usage in this DMV. The other four are pretty straightforward. Replace the “ (ms)” at the end of the counter name with “Base” and you’re good to go.

Advertisements

From → PerfCounter DMV

Comments are closed.

%d bloggers like this: