Tag: High Availability

  • DBA Scripts: Get Replication Status

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: High Availability Transactional replication runs quietly in the background for years without incident, right up until a subscriber falls behind or a publication stops distributing changes, and by then the business impact (a reporting database showing stale data, a downstream system missing…

    Written by

    Peter Whyte

  • DBA Scripts: High Availability

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. High availability isn’t one technology, SQL Server ships several: Always On Availability Groups (the current, supported approach), Database Mirroring (deprecated since 2012 but still running in plenty of environments), Failover Cluster Instances, and Replication (which trades availability guarantees for data distribution instead). Whichever…

    Written by

    Peter Whyte

  • DBA Scripts: Get Replication Agent Status

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: High Availability Publications Look Fine. Are the Agents Actually Keeping Up? Replication Status tells you what’s published and subscribed. It doesn’t tell you whether the jobs actually moving that data, the Log Reader Agent and the Distribution Agent, are keeping up, or…

    Written by

    Peter Whyte

  • DBA Scripts: Get Last Node Blip

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: High Availability When Did This FCI Last Move, and Why On a Failover Cluster Instance (FCI), every node blip, planned or not, causes SQL Server to restart on whichever node picks it up. That restart resets sqlserver_start_time, which makes instance uptime itself…

    Written by

    Peter Whyte

  • DBA Scripts: Get Mirroring Endpoint Health and Status

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Still Running Database Mirroring? Here’s What to Check Database Mirroring has been deprecated since SQL Server 2012, Always On Availability Groups are the supported replacement for any new deployment. But deprecated doesn’t mean gone: plenty of instances still run it, migrations to AG…

    Written by

    Peter Whyte

  • DBA Scripts: Get AG Failover Readiness and Readable Secondary Usage

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Would a Failover Actually Succeed Right Now, and Is Anyone Using the Secondary? AG Replica Role and Synchronization State tells you the current health of every replica. This post answers two sharper, more specific questions on top of that: if the primary failed…

    Written by

    Peter Whyte

Start Here

The Pillars

Blog Categories

Latest Posts

Blog Tags

Access (4) Always On Availability Groups (4) Auditing (7) Backups (6) Blocking (4) Blocking Locking (6) Collectors (7) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (24) Disk Space (5) Extended Events (8) Features (6) High Availability (6) Indexes (7) Installation (7) Inventory (8) Jobs (3) Maintenance (7) Migration (15) Monitoring (27) Performance (21) Performance Troubleshooting (9) PowerShell (4) Query Behaviour (5) Security (10) SQL Agent (5) SQL Scripts (17) SQL Server Administration (10) SQL Server Configuration (7) SQL Server Errors (5) SQL Server High Availability (4) SQL Server Internals (3) SQL Server Management Studio (SSMS) (6) SQL Server Monitoring (7) SQL Server Networking (9) SQL Server Security (7) Storage and Capacity (7) T-SQL (10) Temp DB (3) Tracing (7) Transaction Logs (4) Troubleshooting (24) Windows Server (4)