Thursday, August 2, 2012

Tuning Query Performance


SQL Query Performance Tuning
TechNet: Optimizing SQL Server Query Performance

Query Execution Plans
TechNet: Execution Plan Caching and Reuse

Dynamic Management Views

SQL Profiler
Microsoft TechNet: Using SQL Profiler
http://technet.microsoft.com/en-us/library/cc966515.aspx

Database Engine Tuning Advisor
MSDN: Database Engine Tuning Advisor Overview
http://technet.microsoft.com/en-us/library/ms173494.aspx

No comments: