September 20, 2012 Leave a comment
I find the PAL (Performance Analysis of Logs) tool quite useful in my day-to-day work. One of the latest updates to the tool makes it even cooler: it supports multi-threaded operations. I used to spend quite a bit of time waiting to crunch through even a days worth of Perfmon data in the single threaded mode… of course maybe it was just me watching the pot boil?
In any case, make sure you have the latest version of PAL (2.3.2 at time of writing) and then pay attention to the “Number of processing threads” option on the Execute Screen.
For one point of reference, to process an 80MB perfmon log with 1104 counter instances using SQL Server PAL template running on a 16-core HP DL580 (without Hyper-threading), the duration results for comparison are below, just for fun and to give a little reference:
- 16 Threads: 6 minutes, 27 seconds
- 15 Threads: 6 minutes, 29 seconds
- 8 Threads: 6 minutes, 29 seconds
- 4 Threads: 12 min, 35 seconds
- 1 Thread: 3 hours, 43 minutes, 55 seconds
(Note: I did not rigorously determine that nothing else was running on the server at the times of PAL execution, these are just for relative comparison).
So, if you have the cores, up the thread count, and taste the speed, pal.