Tag: Always On
-
DBA Scripts: Get AG Failover Readiness and Readable Secondary Usage
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: High Availability Would a Failover Succeed Right Now, and Can Reads Reach the Secondary? A failover is coming, planned or not, and you need to know what it costs before anyone presses the button. Get-AgFailoverReadiness answers it per database, per replica: can it…
Written by
Major pillars
Quick scripts
Patch week
Health check & AI
Script areas
Latest posts
- How to Back Up a Database in SQL Server
- Cannot Connect to WMI Provider: SQL Server Configuration Manager Will Not Open
- SQL Server Configuration Manager: Where to Find It and What a DBA Uses It For
- DBA Scripts: Get Failed Login Summary
- Query Was Fast Yesterday, Slow Today: Find What Changed
- The Current Transaction Cannot Be Committed (Error 3930)
Browse by topic
- Backups & Recovery (18)
- DBA Scripts (154)
- High Availability (HA) (13)
- Installation & Configuration (58)
- Maintenance (25)
- Migration & Upgrades (14)
- Monitoring (9)
- Performance Tuning (37)
- Security (Encryption & Permissions) (23)
- Storage & Capacity (17)
- T-SQL Fundamentals (15)
- Troubleshooting (102)
- Wait Types (236)