Joe is a freelance consultant specializing in SQL Server scalability. The common approach to database performance tuning seems to be a laundry list of techniques with no unifying theme. Try random items until something works. Over time, one might develop a feel for what is likely to work in a given situation. This is art. Science is about knowledge. This starts with reverse engineering the details of the SQL Server cost based optimizer, and then developing a quantitative model for the true cost of SQL operations, until one can predict performance characteristics in advance. Joe has also develop several free tools (www.qdpma.com
) for SQL Server performance troubleshooting.
A number of techniques have been discussed for scaling SQL Server on big-iron systems. Some apply to transaction processing, others to data warehouses. However there is very little available guidance on the impact of each for specific application characteristics. Learn which techniques are absolutely essential and which contribute a only few percent.