Performance tuning essentials for SQL Server DBA

This post outlines various options and tools for performing performance tuning on SQL Server. Performance tuning is ongoing, iterative process and it never stops. Typical performance tuning methodologies a