Tag: Monitoring
-
DBA Scripts: Get Database Summary
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration › Server Inventory One Row Per Database, Every Issue Flagged in One Column Checking every database on an instance one at a time, state here, recovery model there, backup age in a third window, doesn’t scale, and it’s exactly the…
Written by
-
DBA Scripts: Run a Full SQL Server Health Check
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › Collectors & Baselines Inherited a server, or sure something is wrong but not what? One command runs 45 read-only checks against the instance. A second turns the results into a ranked CRITICAL / WARNING / INFO list. An optional…
Written by
-
DBA Scripts: Get Job Schedules and Duration Trends
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › SQL Agent & Jobs When Jobs Run, and Whether They’re Taking Longer to Do It SQL Agent Job Failure Summary tells you what broke. These two scripts answer two quieter but just as important questions: Get-JobScheduleSummary shows exactly when…
Written by
-
DBA Scripts: Get Trace Flags and Resource Governor Configuration
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration What a Previous DBA Might Have Set and Never Told You Trace flags and Resource Governor are both instance-wide behavior changes that don’t show up in sp_configure at a glance, don’t appear in the database, and can sit silently in…
Written by
-
DBA Scripts: Get CPU Topology and OS Configuration Checks
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Server & Configuration What CPU and OS Settings Are Actually Doing to SQL Server OS and Hardware Info tells you what hardware exists. These two scripts go one level deeper: how SQL Server is actually scheduling work across that hardware, and whether a…
Written by
-
DBA Scripts: Get Error Log Patterns
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Performance & Troubleshooting Group the Error Log Instead of Scrolling It The SQL Server error log is where the instance tells you what’s wrong, but on a busy server it’s also where hundreds of routine startup, backup, and checkpoint messages bury the handful…
Written by
-
DBA Scripts: Get Log Reuse Waits
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Storage & Capacity The One Question That Actually Matters A transaction log that won’t truncate and keeps growing, or a log backup job that suddenly can’t keep up, always comes back to the same underlying question: what is this database’s log actually waiting…
Written by
-
DBA Scripts: Get TempDB Configuration
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Storage & Capacity TempDB is shared by every database on the instance, and it’s usually the first thing to show contention under load, long before any user database does. Setup has created 1 data file per core (up to 8) since SQL Server…
Written by
-
DBA Scripts: Get Temp DB Hotspots
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Storage & Capacity Temp DB is shared by every database and every session on the instance: temp tables, table variables, sort and hash spills, version store for snapshot isolation, all of it lands in the same handful of files. When Temp DB is…
Written by
-
DBA Scripts: Get SQL Agent Job Failure Summary
🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.In: Maintenance & Automation › SQL Agent & Jobs A job has failed and the notification, if you got one at all, says “The job failed” and nothing else. The real error is sitting in msdb job history for every failed step, but nobody…
Written by
- How to Back Up a SQL Server Certificate and Its Private Key
- 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
- 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) (24)
- Storage & Capacity (17)
- T-SQL Fundamentals (15)
- Troubleshooting (102)
- Wait Types (236)