Tag: Collectors

  • DBA Scripts: Performance and Troubleshooting

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Four Ways of Answering “Why Is It Slow” “The database is slow” is rarely one problem. Sometimes it’s a query, a bad plan, a stale statistic. Sometimes it’s blocking, and the fix is completely different depending on which one it actually is. Sometimes…

    Written by

    Peter Whyte

  • DBA Scripts: Collectors and Baseline Infrastructure

    Part of the DBA-Tools Project, in the Performance and Troubleshooting area. From “Check When Asked” to “Already Watching” Every other pillar on this site answers a question the moment you ask it: what’s blocking right now, what are the current wait stats, how much free space is on disk today. The Collectors pillar is different.…

    Written by

    Peter Whyte

  • DBA Scripts: Generate Collector Alerts

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Performance & Troubleshooting The Job That Reads Every Other Collector and Actually Tells You Something’s Wrong Every collector in this pillar writes evidence somewhere, blocking chains, deadlocks, wait stats, VLF counts, database growth, TempDB pressure. None of them, on their own, tells…

    Written by

    Peter Whyte

  • DBA Scripts: Collect Health and Configuration Baselines

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Performance & Troubleshooting Four Collectors, One Real Table-Design Bug Found Testing Them Four different rhythms: AG health every few minutes if you’re running Availability Groups, index fragmentation weekly, Query Store’s top queries every 30 minutes, error log entries every 10. Testing the…

    Written by

    Peter Whyte

  • DBA Scripts: Collect Capacity and Temp DB Baselines

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Performance & Troubleshooting Three Collectors, Three Real Bugs Found Testing Them DatabaseGrowth and VlfCount are system-versioned temporal tables, always current, no manual history-cleanup needed. The TempDB collector snapshots both file-level space and the top 10 session consumers in one pass. All three…

    Written by

    Peter Whyte

  • DBA Scripts: Collect Performance Baselines (Wait Stats, Perfmon, Storage I/O)

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Performance & Troubleshooting Three Cumulative Counters, Three Matching Delta Scripts sys.dm_os_wait_stats, sys.dm_os_performance_counters, and sys.dm_io_virtual_file_stats are all cumulative since the instance last started, a raw snapshot of any of them tells you almost nothing on its own. Three collector generators snapshot each on…

    Written by

    Peter Whyte

  • DBA Scripts: Collect Blocking and Deadlock Events

    🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks.Related pillar: Performance & Troubleshooting Standing Watch for Blocking and Deadlocks, Not Just Checking When Asked Get Blocking Sessions and Get Deadlock Summary answer “what’s happening right now.” These two generators answer a different question: “what happened while nobody was looking.” Each creates a…

    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)