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
- SQL Server Performance Monitor Counters
- 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
Information About Resource Waits
Wait stats will help you discover bottlenecks on your system.