[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search

 
Tuning

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019
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.