3 ms·
This is yet another awesome contribution from Netflix. Just curious though, anyone know of a similar type of writeup or post regarding windows? I have an MSSQ
by samstave 11y ago
This is yet another awesome contribution from Netflix.
Just curious though, anyone know of a similar type of writeup or post regarding windows?
I have an MSSQL box I want to kill with fire - but I would like to be able to measure its perf with as much insight as I might on a comparable linux box.
What is the best way to measure disk IO perf on a windows box, specifically?
- Splines 11y agoxperf/wpr. Launch wprui, select First Level Triage and Disk I/O and File I/O, make sure logging mode is set to Memory, then click Start. Let it run for a minute, click Stop, then open up the generated ETL in WPA. From there it's hard to tell you what to do in WPA. Documentation isn't the greatest, but this link is close to what you're trying to do: http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/03/19/troubleshooting-sql-server-high-cpu-usage-using-xperf.aspx http://blogs.msdn.com/b/sql_pfe_blog/archive/2013/03/19/trou... Drag in the relevant graphs into your current view, and understand how the yellow bar aggregates data. MSSQL probably has event providers - you might want to look those up and add them to wprui when you generate your ETL.