[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search

 Tuning
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
SQL Server 2008
SQL Server 2012
SQL Server 2014
Tips
Troubleshooting
Tuning

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.