Sql server Extended events query

Question

Sql server Extended events query

jaya

SSCrazy

Points: 2109
More actions
January 30, 2012 at 2:25 pm

#250422

I am trying to collect performance counter values from Extended Events.
Successfully collected counter values for %processortime & %previligedtime and used counter type & cooking formula to get actual values out of raw values.
For converting counter average_disk_bytes_per_write(logical disk) I need Average_disk_bytes_per_write_base as the formula is X1-X0/B1-B0 where denominator B is value of Base counter and Numerator X is value of actual counter.
I am not sure how to get base counter values from Extended events. The following query which retuns all the available performance counters through event sessions
SELECT name, object_name, description
FROM sys.dm_xe_object_columns
WHERE object_name like '%physical_page_read%'
AND description IS NOT NULL
AND NOT name in ('ID', 'UUID', 'VERSION','CHANNEL', 'KEYWORD')
ORDER BY object_name, name
I cannot find base counter name anywhere. Could anyone suggest how to get base counter values from Extended events. If not how to get refined values out of raw values for Avg_disk_bytes_per_write

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

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

Jonathan Kehayias One Orange Chip Points: 26778 More actions · Answer 1

The base values aren't provided in the perfobject_logical_disk event and you can't derive what that base is from the physical_page_read event, which tracks individual page reads, not the actual I/O to the disk. You can have a single async_io_completed event that fetches up to 128 pages with readahead prefetch under Enterprise Edition and that is a single I/O logically.

The perfobject_* events aren't quite as useful as you initially think they are once you look at what is being returned and what isn't.

jaya SSCrazy Points: 2109 More actions · Answer 2

Hi Jonathan Kehayias

Thanks so much for the information. I guess extended events are not that useful to get Logical disk information. I shall use WMI scripting to get the information.

Thank you..

Jaya