Troubleshooting Performance Problems in SQL Server 2005

by jasonstrate, posted in Performance Tuning & Tracing, SQL Server, White Paper

I was working through some performance issues on a "fun" table.  A bit of half a billion rows and with some apparent I/O issues as the entire table is being read by some of the clients services to create an extract.  In working through some of the performance bottlenecks, I found the following white paper quite helpful… of course, the name of the white paper indicates how helpful it was… Troubleshooting Performance Problems in SQL Server 2005.