[Company Logo Image] 

Home Contents Coffee Break Credits Glossary Links Search




Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019

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.