SQL Server Perfmon (Performance Monitor) Best Practices

In a recent post I wrote that there are many ways to solve a problem.

In this post I will talk about the Perfmon and specifically about performance counters collection. Brent Ozar wrote a great article a while back on the Perfmon Best practices and in his article he suggests the use of perfmon logs and

Continue reading […] SQL Server Perfmon (Performance Monitor) Best Practices […]

 

So many ways to solve a problem

I remember, as a kid my dad got me a Rubic’s cube. It seemed quite shiny and cool. And kinda hard to fix.

After a while, though, in the process of figuring out how to set it back in order i found a great solution: I took one of my dad’s screwdrivers, disassembled the Rubic’s cube

Continue reading […] So many ways to solve a problem […]

 

Features compare of Perfmon and Event Tracing for Windows

PerfCounters

100ms sampled
Aligned to system timer
Restricted by API
High-level diagnostic
Less overhead for continuous event

For more info about Performance Counters read here.

 

Event Tracing

Discrete Events
Accurate CPU utilization
Freeform data
Detailed system info
ISR/DPC info

For more info about ETW (Event Tracing for Windows) read here.