Tag: Maintenance
-
DBA Scripts: Generate Maintenance Jobs
Part of the DBA-Tools Project. Building a Full SQL Server Maintenance Job Framework You Can Actually Read If you’re already running Ola Hallengren’s maintenance solution, this won’t replace it, but the approach here might still be useful: three small, readable T-SQL generator scripts that build the same category of scheduled job framework (full and log…
Written by
-
DBA Scripts: Get Maintenance Job Status
Part of the DBA-Tools Project. A maintenance job that’s silently failing is one of the more dangerous states a SQL Server instance can be in, because everything looks normal from the outside. The database is online, queries run fine, and the index maintenance or stats update job that’s supposed to be keeping things healthy has…
Written by
Blog Categories
- Backups & Recovery (7)
- DBA Scripts (98)
- High Availability (HA) (7)
- Installation & Configuration (14)
- Maintenance (4)
- Monitoring (14)
- Performance Tuning (11)
- Security (Encryption & Permissions) (6)
- T-SQL Fundamentals (11)
- Troubleshooting (10)
- Wait Types (201)
Latest Posts
- DBA Scripts: Generate Migration Scripts
- DBA Scripts: Generate Maintenance Jobs
- DBA Scripts: Get Job Schedules and Duration Trends
- How to Shrink SQL Server Database Files in Chunks
- DBA Scripts: Get Lock Escalation, Contention Analysis, and Blocking Chains with Plan
- DBA Scripts: Get Trace Flags and Resource Governor Configuration
Blog Tags
Access (3) Always On Availability Groups (4) Auditing (7) Backups (4) Blocking Locking (6) Database Backups & Recovery (8) Database Backups and Recovery (5) Database Maintenance (7) DBA Tools (28) Disk Space (5) Error Log (2) Extended Events (7) Features (6) High Availability (6) Indexes (5) Instance (3) Inventory (6) Jobs (3) Migration (7) Monitoring (24) Performance (19) Performance Troubleshooting (9) PowerShell (4) Queries (3) Query Behaviour (5) Security (7) SQL Agent (3) SQL Scripts (21) 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 (9) SQL Server Versions (2) Storage and Capacity (9) T-SQL (9) Temp DB (3) Tracing (7) Transaction Logs (5) Troubleshooting (14) Windows Server (4)