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.

 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.