Use Perfmon counters for bottleneck analysis CPU graph #193

microsoft / SqlNexus

SQL Nexus is a tool that helps you identify the root cause of SQL Server performance issues. It loads and analyzes performance data collected by SQL LogScout, SQLDiag or PSSDiag. It can dramatically reduce the amount of time you spend manually analyzing data.

MIT License

356 stars 101 forks source link

Use Perfmon counters for bottleneck analysis CPU graph #193 #195

Closed PiJoCoder closed 1 year ago

PiJoCoder commented 1 year ago

The graph has been using output from the sys.dm_os_ring_buffers but that data is sometimes incorrect and the DMV is marked not supported any more. Therefore this PR switches to using data from Perfmon counters (what people are used to using) and hopefully it is more accurate.

PiJoCoder commented 1 year ago

This graph uses Perfmon counters if they are available

PiJoCoder commented 1 year ago

@Juergen_Horn tested this and reported looks good.