What is the minute interval that u have. I am seeing changing the minute interval is giving different spike graphs. I am not sure of how am suppose to understand this yet. Am bit confuse if changing from 5 minutes interval to 2 minutes, or 30 minutes , if tableau aggregating the the data and giving the spike's results.
We have 8 core, and only one time i saw 802% spike as max.
In ur post when you say- "See the 3rd row in the attached screenshot", may i know where ur referring to ?. I am just curious.
I have a question. I am seeing in ur screenshot that the Timestamp offset is 0. Shouldn't that be changed to match ur time zone to offset the GMT time ?.
The 3rd row in the screenshot shows a "%_processor_time" value of "17312.88". %_processor_time is a column in the TabMon Postgres database, and what you see in the screenshot isn't being aggregated or otherwise calculated by the Tableau TabMon workbook.
Here's a screenshot of the same value by querying the countersamples table from pgAdmin. See row #2.
President & Chief Architect
2 of 2 people found this helpful
TabMon just writes out the raw values it gets from PerfMon without modifying them in any way -- no secret sauce there. The results you are seeing are due to the "% Processor Time" counter in Perfmon being notoriously weird and counterintuitive. Not only is this the value of this counter amplified by the number of logical processors as you noted, but extensive multithreading within a process amplifies it as well -- this is why you are seeing values get so ridiculously high. Because this counter is hardware context-dependent, it should be used as a relative benchmark only against the host system itself.
For more info on how this counter works, check out this article on TechNet.. the grammar is a little rough but the message is solid: