SQLCoffee - Tuning and Optimization

Performance Tuning and Optimization.

Enable the Lock Pages in Memory Option
This Windows Security policy must be enabled to configure Address Windowing Extensions (AWE).

Troubleshooting I/O Bottleneck
Script to identify and analyze the queries that are generating the most I/Os.
SQL Server Performance Monitor Counters are Missing
When you use the SQL Performance Monitor, some or all of the Microsoft SQL counters are missing.
System Stored Procedure sp_recompile
Use sp_recompile to reoptimized the queries inside your stored procedures.

Information About Resource Waits
Wait stats will help you discover bottlenecks on your system.

(追記) (追記ここまで)