Identify blocking problems
How to recognise a blocking problem, set up the collection of blocked process reports, and send the files for analysis.
Tag: SQL Server
A complete guide to SHRINK in SQL Server
How to reduce the size of a SQL Server database file properly: good practice, sizing, an incremental strategy, and automation with dbatools.
Categories:
8 minute read
SQL Server Standard: understanding Basic Availability Groups (BAG)
The Standard edition of SQL Server offers one high availability solution: Basic Availability Groups. Here are their benefits and their limits.
Categories:
Always On: mastering the timeouts
Lease Timeout, HealthCheck, Quorum… Configure the SQL Server and WSFC thresholds to stabilise your high availability.
Categories:
Why you should NOT multiply SQL Server instances
Consolidating SQL Server instances is better than installing several of them on the same server.
Categories:
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
Basic counters
Windows and SQL Server counters to monitor
Categories:
Order a remote SQL Server audit
Order a remote SQL Server audit without a preliminary call. Provide the audit scope and the details needed for invoicing.
Categories:
2 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
Monitoring with PRTG
A guide to configuring PRTG for SQL Server monitoring
Categories:
Updating SQL Server: CUs, GDRs and servicing branches
The SQL Server servicing model since 2017: choosing between the CU branch and the GDR branch, reading a build number, finding the right update and applying it.
Categories:
12 minute read
SQL Server transaction log backups: why and how
In the FULL recovery model, transaction log backups are indispensable. They limit data loss, allow point-in-time restores, and stop the log from filling the disk.
Categories:
11 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
Managing the SQL Server Transaction Log
A transaction log filling up the disk is a classic DBA problem. Learn how to diagnose blocking issues and properly configure your recovery models.
Categories:
5 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