Identify blocking problems
How to recognise a blocking problem, set up the collection of blocked process reports, and send the files for analysis.
Performance
Improve and fix performance.
Use ABORT_QUERY_EXECUTION to block query execution in SQL Server 2025
Using ABORT_QUERY_EXECUTION in SQL Server 2025 to block the execution of problem queries through Query Store Hints.
Fix cardinality estimator problems
How to identify and fix performance problems caused by the cardinality estimator.
Get an execution plan
How to get a query execution plan in SQL Server
Fix implicit conversions
How to identify implicit conversion problems and fix them
Optimize SQL queries
A methodology for optimizing queries in SQL Server
Enable and use the Query Store
How to enable and use the Query Store to diagnose performance problems.
Read Committed Snapshot
How to enable the Read Committed Snapshot option in a SQL Server database
Troubleshoot performance problems
How to diagnose performance problems in SQL Server
SQL Server Parallelism: Configuring MAXDOP and Cost Threshold
SQL Server’s default parallelism settings are often the cause of slowdowns. Configure MAXDOP and Cost Threshold (CTFP) to optimize your performance.