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
Do not break your indexes — SARGability and WHERE clause anti-patterns
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
Why SQL Server Consumes All Your Server's RAM (and Why It's Normal)
Understanding SQL Server’s memory management behavior for system administrators accustomed to other platforms
Categories:
7 minute read