Bill Graziano Tunes Up Our SQL Server Queries!
Richard and Greg talk to Bill Graziano about performance tuning in SQL Server. Bill digs into using SQL Profiler to focus on where the problems lie. The discussion digs into the procedure cache and how you can optimize your queries for caching. He also talks about ClearTrace, a free tool he distributes to help understand trace data. Check it out at http://www.cleardata.biz.
Audio is streamed directly from the publisher (cdn.simplecast.com) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
Richard and Greg talk to Bill Graziano about performance tuning in SQL Server. Bill digs into using SQL Profiler to focus on where the problems lie. The discussion digs into the procedure cache and how you can optimize your queries for caching. He also talks about ClearTrace, a free tool he distributes to help understand trace data. Check it out at http://www.cleardata.biz.