I had a great time in Portland, Oregon on Saturday, where I spoke on using the new features in SQL Server 2008 for Performance Tuning. We covered the new Performance Tracking and Tuning tools in the product, but I focused more on the process for performance tuning. It's fairly simple to locate books, websites and so on for the metrics you should collect and what they mean. But how do you start? Where do you start? I submitted the following "circle" of actions for a perf tuning engagement:
- Define the Components in the System to be measured (from the client to the server)
- Collect Metrics
- Compare to a Benchmark (your own previous collections are best)
- Locate the Bottleneck
- Tune and Test
- Later, Rinse, Repeat
I did mention I would try and post my code on my blog today, but it turns out I can't post files here - just pictures. If you attended the briefing, you have my e-mail, so feel free to drop me a line and I'll send them to you.