I needed to setup bandwidth shaping on a router recently for testing purposes and decided on the below configuration on my Cisco router. I know this drops packets and I don’t really care; this is a guest network and it isn’t mission critical.
Bug Check Code Reference from MSDN
This is a quick video of what I was working on for a little today. I created a batch script that will benchmark a disk(s) using SQLIO and record the output to a single file (or multiple, if necessary). After benchmarking completes, I run SQLIOResults and choose the output file that was created by my batch script.
I have read numerous articles all over the ‘net regarding performance counters to monitor, etc.
One of probably hundreds of SQL scripts out there. This is what I made and use… and I like it.