SQL Server Administration

The Standard edition of SQL Server offers one high availability solution: Basic Availability Groups. Here are their benefits and their limits.

Lease Timeout, HealthCheck, Quorum… Configure the SQL Server and WSFC thresholds to stabilize your high availability.

Windows and SQL Server counters to monitor: CPU, disk latency, buffer cache hit ratio, page life expectancy, transactions and batches per second.

Configure PRTG to monitor SQL Server with the PerfCounter Custom sensor: counter syntax, units, and computing the buffer cache hit ratio.

Why a database in the FULL recovery model needs log backups, what VM backups do not replace, and how to restore to a precise point in time.

11 minute read

Category: SQL Server Administration