Headed to Chicago tomorrow for SQL Saturday #67. Heading out a day early to attend a pre-conference seminar on Friday on troubleshooting and performance tuning. While I feel pretty strong in these areas, one thing I haven’t done as good of a job of as I should is keeeping up on new features to assist with this in SQL Server 2005 and 2008. Dynamic Management Views, Extended Events, and so forth. So this should be a good class to help teach an old dog new tricks. Then on Saturday I get to present the XML session again which I created for Utah Code Camp. Looking forward to it.
Following a Structure When Performance Tuning, Part 2: Identifying Problem Statements
If you’ve followed along with the previous blog, you’ll now have a way to re-run and test your query as well as measuring any changes.