Performance Tuning using SQL Server 2008 from SQL Saturday 12

Performance Tuning using SQL Server 2008 from SQL Saturday 12

Rate This
  • Comments 1

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:

  1. Define the Components in the System to be measured (from the client to the server)
  2. Collect Metrics
  3. Compare to a Benchmark (your own previous collections are best)
  4. Locate the Bottleneck
  5. Tune and Test
  6. 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.

Leave a Comment
  • Please add 7 and 7 and type the answer here:
  • Post
  • It is always a pleasure seeing one of your presentations. Thanks for letting me be your data warehouse. A colleague suggested that the next time I am picked as a data warehouse, I should move up and down the first row shaking hands with everyone, to better illustrate my function.

Page 1 of 1 (1 items)