Identify blocking problems
How to recognise a blocking problem, set up the collection of blocked process reports, and send the files for analysis.
Tag: Performance
Remote SQL Server Audit
Remote SQL Server audit: report, SQL commands and three to five priorities within five working days, with no consultant access to your network.
Categories:
12 minute read
Example audit report
A real SQL Server audit report, anonymised, as it is delivered: the measurements, the findings, the recommendations and the questions put to the client.
Categories:
29 minute read
Query Store capture modes
What separates the ALL, AUTO, CUSTOM and NONE Query Store capture modes, with the AUTO thresholds measured on SQL Server 2019, 2022 and 2025.
Categories:
8 minute read
What the Query Store records
What the Query Store keeps about a query and what it leaves out: missing statements, interrupted executions, losses after a hard shutdown.
Categories:
8 minute read
SQL Server string statistics
The string summary of a SQL Server statistics object, decoded: a sample of strings stored in a trie, how it estimates LIKE predicates, and what bypasses it.
Categories:
30 minute read
SARGability of WHERE clauses
Why functions in your WHERE clauses stop SQL Server from using your indexes, and how to rewrite your queries to get performance back.
Categories:
7 minute read
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.
Categories:
9 minute read
SQL Server memory consumption
Understanding SQL Server’s memory management behavior for system administrators accustomed to other platforms
Categories:
7 minute read