DBAOPS TELEMETRY DATA COLLECTION CATALOG
Security | Optimization | Consistency | Integration | Integrity | Availability | Compliance

Purpose:
This document lists the telemetry data that DBAs should collect while administering database environments made up of different server systems, workloads, and database platforms. The goal is to support security, optimization, consistency, integration, integrity, reliability, capacity planning, compliance, and operational governance.

===============================================================================
1. SERVER / HOST INVENTORY TELEMETRY
===============================================================================

Collect foundational metadata for every server.

- Server name
- Fully qualified domain name (FQDN)
- Domain
- Environment: Production, Test, Development, QA, DR, Staging
- Location / data center / cloud region
- Business unit
- Application owner
- DBA owner
- Server role
- OLTP role
- OLAP role
- ETL role
- Reporting role
- Replication role
- Publisher / Distributor / Subscriber role
- Archive role
- Staging role
- Operating system version
- Windows build number
- OS edition
- OS install date
- Last boot time
- Uptime
- CPU sockets
- CPU cores
- Logical processors
- NUMA nodes
- RAM
- Disk layout
- Volume layout
- Mount points
- Virtualization platform
- VMware / Hyper-V / Azure / AWS / physical server
- VM tools status
- VM resource allocation
- IP address
- DNS name
- Subnet
- Gateway
- NIC speed
- DNS registration
- Production criticality
- Support group
- Patch level
- Pending reboot status
- Supported / unsupported OS status
- Supported / unsupported SQL Server version status
- End-of-support risk

===============================================================================
2. SQL SERVER INSTANCE INVENTORY
===============================================================================

Collect metadata for each SQL Server instance.

- Instance name
- Server name
- Default instance or named instance
- SQL Server service name
- SQL Agent service name
- SQL Server port
- Dynamic or static port
- SQL Server product version
- SQL Server edition
- SQL Server CU level
- SQL Server build number
- SQL collation
- Max server memory
- Min server memory
- MAXDOP
- CTFP / Cost Threshold for Parallelism
- Startup parameters
- Trace flags
- Tempdb startup location
- sp_configure settings
- CLR status
- xp_cmdshell status
- Remote admin connections status
- Database Mail XPs status
- Agent XPs status
- Ole Automation Procedures status
- Ad hoc distributed queries status
- Query Store configuration
- Lightweight query profiling status
- SQL authentication mode
- Windows-only authentication
- Mixed mode authentication
- SA account status
- Failed login audit status
- SQL Engine service account
- SQL Agent service account
- SSIS service account
- gMSA usage status
- SQL Agent running status
- Operators configured
- Alerts configured
- CMS registration status
- CMS group
- Source-of-truth inventory status

===============================================================================
3. CORE SQL CONFIGURATION METRICS
===============================================================================

Collect configuration settings that affect performance, security, and consistency.

- Max server memory
- Min server memory
- MAXDOP
- CTFP / Cost Threshold for Parallelism
- Optimize for ad hoc workloads
- Backup compression default
- Remote admin connections
- CLR enabled
- xp_cmdshell enabled or disabled
- Ad hoc distributed queries
- Ole Automation Procedures
- Database Mail XPs
- Agent XPs
- Query Store state
- Query Store capture mode
- Query Store max size
- Query Store cleanup policy
- Lightweight query profiling
- Contained database authentication
- Common Criteria compliance enabled
- Default backup compression
- Default trace status
- Blocked process threshold
- Remote query timeout
- Network packet size
- Server trigger inventory
- Server audit status
- Login auditing mode

===============================================================================
4. CPU TELEMETRY
===============================================================================

Collect Windows-level and SQL-level CPU signals.

- Total CPU usage percentage
- SQL Server CPU usage percentage
- Other process CPU usage percentage
- CPU queue length
- Signal waits
- Runnable tasks count
- Scheduler monitor data
- Non-yielding scheduler events
- NUMA node CPU usage
- Parallel query count
- CXPACKET waits
- CXCONSUMER waits
- SOS_SCHEDULER_YIELD waits
- Compilation CPU
- Recompilation rate
- Top CPU queries
- CPU by database
- CPU by application
- CPU by login
- CPU by host/client
- CPU by workload type
- CPU by time interval
- CPU trend
- CPU saturation events
- Processor queue length
- Context switches/sec
- Thread count
- Worker thread usage
- Worker thread exhaustion
- THREADPOOL waits

===============================================================================
5. MEMORY TELEMETRY
===============================================================================

Collect memory usage and pressure indicators.

- Total physical memory
- Available memory
- SQL target server memory
- SQL total server memory
- Memory grants pending
- Memory grants outstanding
- Memory grant requested
- Memory grant used
- Buffer cache hit ratio
- Page life expectancy
- Lazy writes/sec
- Checkpoint pages/sec
- Free list stalls/sec
- Stolen memory
- Plan cache size
- Procedure cache hit ratio
- Buffer pool usage by database
- Buffer pool usage by object
- Buffer pool usage by index
- Memory clerks
- Memory nodes
- Columnstore object pool memory
- In-memory OLTP memory usage
- External process memory usage
- SSIS process memory
- Antivirus / EDR memory impact
- Max memory compliance
- Memory pressure alerts
- Resource semaphore waits
- RESOURCE_SEMAPHORE_QUERY_COMPILE waits

===============================================================================
6. DISK / STORAGE TELEMETRY
===============================================================================

Collect capacity, latency, and storage health data.

- Disk free space
- Disk free percentage
- Volume size
- Mount point size
- Mount point free space
- Data file drive latency
- Log file drive latency
- Tempdb drive latency
- Backup drive latency
- Read latency in milliseconds
- Write latency in milliseconds
- IOPS
- Throughput MB/sec
- Avg disk queue length
- File growth events
- Instant file initialization status
- SQL data file size
- SQL log file size
- VLF count
- VLF status
- Data/log/tempdb/backup file placement
- Thin provisioning risk
- Storage snapshot events
- Disk errors
- Windows event log storage errors
- IO warnings
- SQL errors 823, 824, and 825
- Backup repository free space
- Forecasted storage exhaustion date

===============================================================================
7. TEMPDB TELEMETRY
===============================================================================

Tempdb is a critical performance and stability area.

- Tempdb file count
- Tempdb file sizes
- Tempdb autogrowth settings
- Tempdb drive free space
- Tempdb version store size
- Tempdb user object allocation
- Tempdb internal object allocation
- Tempdb spills
- Sort warnings
- Hash warnings
- PAGELATCH waits
- PFS contention
- GAM contention
- SGAM contention
- Tempdb metadata contention
- Active tempdb consumers
- Tempdb log usage
- Version cleanup rate
- Snapshot isolation impact
- ADR persistent version store
- Tempdb growth events
- Tempdb file usage imbalance
- Tempdb wait statistics
- Tempdb session usage
- Tempdb task usage

===============================================================================
8. WAIT STATISTICS TELEMETRY
===============================================================================

Waits should be collected as interval deltas, not only cumulative totals.

Core metrics:
- Wait type
- Wait time in milliseconds
- Signal wait time in milliseconds
- Resource wait time
- Waiting tasks count
- Average wait time
- Waits by database
- Waits by query hash
- Waits by session
- Waits by workload
- Wait deltas between collection intervals

Important waits to monitor:
- CXPACKET
- CXCONSUMER
- SOS_SCHEDULER_YIELD
- PAGEIOLATCH_SH
- PAGEIOLATCH_EX
- WRITELOG
- ASYNC_IO_COMPLETION
- BACKUPIO
- LCK_M_S
- LCK_M_X
- LCK_M_U
- LCK_M_IS
- LCK_M_IX
- PAGELATCH_SH
- PAGELATCH_EX
- RESOURCE_SEMAPHORE
- RESOURCE_SEMAPHORE_QUERY_COMPILE
- THREADPOOL
- OLEDB
- ASYNC_NETWORK_IO
- HADR_SYNC_COMMIT
- HADR_DATABASE_FLOW_CONTROL
- HADR_LOGCAPTURE_WAIT
- HADR_WORK_QUEUE
- REPL_SCHEMA_ACCESS
- REPL_CACHE_ACCESS
- LOGMGR_QUEUE
- PREEMPTIVE_OS_AUTHENTICATIONOPS
- PREEMPTIVE_OS_FILEOPS
- PREEMPTIVE_COM_QUERYINTERFACE
- CMEMTHREAD
- LATCH_EX
- LATCH_SH
- IO_COMPLETION

===============================================================================
9. QUERY PERFORMANCE TELEMETRY
===============================================================================

Collect workload and query-level performance data.

- Top CPU queries
- Top duration queries
- Top logical read queries
- Top physical read queries
- Top write queries
- Execution count
- Average duration
- Maximum duration
- Minimum duration
- Query hash
- Query plan hash
- SQL text
- Query plan
- Compile time
- Recompile count
- Memory grant requested
- Memory grant used
- Memory grant wasted
- Sort spills
- Hash spills
- Tempdb spills
- Degree of parallelism used
- Parallel worker usage
- Missing index recommendations
- Unused index candidates
- Query Store regressions
- Query Store forced plans
- Failed forced plans
- Parameter sensitivity
- Parameter sniffing indicators
- Blocking chains
- Deadlocks
- Timeout errors
- Attention events
- Application name
- Login name
- Host name
- Database name
- Waits per query
- CPU per query
- Reads per query
- Writes per query

===============================================================================
10. INDEX TELEMETRY
===============================================================================

Collect index health, usage, and optimization data.

- Index fragmentation percentage
- Page count
- Index size
- Index depth
- Fill factor
- Page splits/sec
- Forwarded records
- Heap tables
- Missing indexes
- Duplicate indexes
- Overlapping indexes
- Unused indexes
- Index seeks
- Index scans
- Index lookups
- Index updates
- Disabled indexes
- Hypothetical indexes
- Filtered indexes
- Columnstore rowgroup health
- Columnstore deleted rows
- Columnstore trim reason
- Columnstore compressed rowgroups
- Columnstore open rowgroups
- Columnstore delta stores
- Statistics age
- Statistics modification counter
- Auto-created statistics
- Auto-updated statistics
- Persisted sample percent
- Last statistics update date
- Index maintenance history
- Index rebuild duration
- Index reorganize duration
- Index compression setting
- Partitioned index status

===============================================================================
11. PAGE / BUFFER POOL TELEMETRY
===============================================================================

Collect page-level memory and buffer pool indicators.

- Page life expectancy
- Buffer cache hit ratio
- Database pages
- Dirty pages
- Free pages
- Stolen pages
- Lazy writes/sec
- Page reads/sec
- Page writes/sec
- Readahead pages/sec
- Checkpoint pages/sec
- Page splits/sec
- Page latch waits
- Hot pages
- Allocation page contention
- Buffer pool by database
- Buffer pool by object
- Buffer pool by index
- Data cache pressure
- Dirty page ratio
- Checkpoint pressure

===============================================================================
12. DATABASE INVENTORY AND HEALTH TELEMETRY
===============================================================================

Collect health and configuration details for every database.

- Database name
- Database ID
- Database owner
- Create date
- Database state
- Online/offline/restoring/suspect/recovery pending status
- Recovery model
- Compatibility level
- Collation
- Containment status
- Read-only status
- Auto close status
- Auto shrink status
- Auto create statistics
- Auto update statistics
- Auto update statistics async
- Query Store status
- ADR status
- Snapshot isolation status
- Read committed snapshot status
- Trustworthy status
- DB chaining status
- TDE status
- Encryption state
- Last full backup
- Last differential backup
- Last transaction log backup
- Last DBCC CHECKDB
- DBCC CHECKDB result
- Suspect pages
- Orphaned users
- File growth settings
- File free space
- Log reuse wait reason
- Database size
- Data file size
- Log file size
- Database growth rate
- Database criticality
- Application mapping
- Data classification

===============================================================================
13. TRANSACTION LOG TELEMETRY
===============================================================================

Collect log health and recoverability metrics.

- Log file size
- Log used percentage
- VLF count
- VLF status
- Log growth events
- Last log backup time
- Log backup frequency
- Log backup duration
- Log backup size
- Log reuse wait reason
- Active transactions
- Oldest active transaction
- Replication log retention
- CDC log scan latency
- Change tracking cleanup status
- AG send queue
- AG redo queue
- WRITELOG waits
- Log flushes/sec
- Log bytes flushed/sec
- Log flush wait time
- Long-running transaction count
- Open transaction count
- Log truncation blockers
- Log shipping status where applicable

===============================================================================
14. BACKUP AND RESTORE TELEMETRY
===============================================================================

Collect recoverability and backup governance metrics.

- Last full backup
- Last differential backup
- Last transaction log backup
- Backup duration
- Backup size
- Compressed backup size
- Backup compression ratio
- Backup throughput MB/sec
- Backup location
- Backup media type
- Backup encryption status
- Backup checksum status
- Backup verification status
- Restore test status
- Backup chain continuity
- Missing log backups
- Failed backups
- Copy-only backup events
- Veeam job status
- Veeam transaction log backup status
- Veeam application-aware processing status
- Veeam repository free space
- Retention compliance
- Immutable backup status
- Offsite copy status
- Backup SLA compliance
- RPO compliance
- RTO compliance
- Restore history
- Restore validation result
- Point-in-time recovery readiness

===============================================================================
15. SQL AGENT TELEMETRY
===============================================================================

Collect SQL Agent job, schedule, and alerting telemetry.

- SQL Agent service status
- Job enabled/disabled status
- Job last run status
- Job last run duration
- Job next run time
- Job owner
- Job category
- Job step command
- Job step subsystem
- T-SQL job steps
- PowerShell job steps
- CmdExec job steps
- SSIS job steps
- Failed job steps
- Retry attempts
- Long-running jobs
- Overlapping jobs
- Missed schedules
- Disabled schedules
- Alerts configured
- Operators configured
- Database Mail profile used
- Proxy accounts
- Credentials
- Job output files
- Job history retention
- Job failure notification status
- Maintenance job status
- ETL job status
- Backup job status
- Replication agent job status

===============================================================================
16. WINDOWS SERVICES TELEMETRY
===============================================================================

Monitor services that affect database operations.

Services to monitor:
- SQL Server Database Engine
- SQL Server Agent
- SQL Server Browser
- SQL Server Integration Services
- SQL Server Reporting Services
- SQL Server Analysis Services
- SQL Server Full-Text Search
- Distributed Transaction Coordinator / MSDTC
- SQL Server VSS Writer
- Veeam LogShipper
- RPC Locator
- Windows Event Log
- WinRM
- WMI
- Tanium Client
- Antivirus / EDR services
- Backup agents
- Monitoring agents
- Cluster service
- Netlogon
- Windows Time service
- DNS Client
- Volume Shadow Copy
- VMware Tools / Hyper-V Integration Services

Metrics to collect:
- Service name
- Display name
- Current state
- Startup type
- Service account
- Last start time
- Failure count
- Recovery action
- Recent service crashes
- Disabled services
- Services running under non-standard accounts
- Unexpected service stoppage
- Service restart history

===============================================================================
17. SECURITY TELEMETRY
===============================================================================

Collect identity, access, encryption, and audit data.

Authentication and access:
- SQL logins
- Windows logins
- Windows groups
- Sysadmin members
- Server role membership
- Database role membership
- Orphaned users
- Disabled logins
- Dormant logins
- Failed logins
- Successful privileged logins
- SA enabled or disabled
- SA renamed status
- Mixed mode status
- Password policy enforced
- Password expiration enforced
- Weak SQL logins
- Service account permissions
- gMSA adoption status
- Login default database
- Login expiration
- Login lockout
- Privileged account usage
- Break-glass account inventory

Permissions:
- Server-level permissions
- Database-level permissions
- Object-level permissions
- Ownership chains
- EXECUTE AS usage
- TRUSTWORTHY database status
- Cross-database ownership chaining
- UNSAFE assemblies
- Linked server mappings
- Credentials
- SQL Agent proxies
- Public role permissions
- Guest user permissions
- Database ownership
- Schema ownership

Encryption:
- TDE enabled status
- TDE encryption state
- DEK algorithm
- Certificate name
- Certificate expiration
- Certificate backup status
- Database master key status
- Service master key health
- Backup encryption status
- Connection encryption
- SQL certificate binding
- Force Encryption status
- TrustServerCertificate usage
- TLS version
- Always Encrypted usage
- EKM usage
- Azure Key Vault integration
- Key rotation history

Audit and compliance:
- SQL Audit status
- Audit target
- Audit failure action
- DDL changes
- Permission changes
- Role membership changes
- Login creation/deletion
- Failed access attempts
- Sensitive table access
- Data export events
- xp_cmdshell use
- Linked server activity
- PowerShell job activity
- Backup and restore activity
- Security baseline drift
- Policy violations

===============================================================================
18. INTEGRITY TELEMETRY
===============================================================================

Collect database integrity and corruption indicators.

- Last DBCC CHECKDB date
- DBCC CHECKDB result
- CHECKDB duration
- PHYSICAL_ONLY check status
- Full CHECKDB status
- Suspect pages
- Page checksum failures
- Torn page detection
- Database state changes
- Recovery pending events
- SQL error 823
- SQL error 824
- SQL error 825
- Fatal errors
- Consistency check failures
- Backup checksum failures
- Restore verification failures
- Corruption alerts
- Repair actions
- Table-level consistency checks
- Allocation consistency
- Catalog consistency
- Indexed view consistency
- Service Broker consistency where used

===============================================================================
19. ETL / SSIS / DATA PIPELINE TELEMETRY
===============================================================================

Collect operational, quality, and performance telemetry for pipelines.

- Package name
- Project name
- Folder name
- Environment name
- Execution ID
- Start time
- End time
- Duration
- Status
- Error message
- Failed task
- Failed component
- Rows read
- Rows written
- Rows rejected
- Rows redirected
- Lookup failures
- Truncation errors
- Conversion errors
- Source connection
- Destination connection
- Connection failures
- Package parameters
- Environment variables
- Retry count
- Checkpoint restart usage
- Data latency
- SLA compliance
- File arrival status
- Queue depth
- Watermark value
- CDC lag
- Change Tracking lag
- Duplicate rows detected
- Referential integrity errors
- ETL CPU usage
- ETL memory usage
- ETL tempdb usage
- ETL log table growth
- Batch ID
- Load ID
- Source-to-target reconciliation
- Row count comparison
- Data freshness timestamp

===============================================================================
20. OLTP WORKLOAD TELEMETRY
===============================================================================

Collect transaction-processing performance and concurrency metrics.

- Transactions/sec
- Batch requests/sec
- User connections
- Active sessions
- Requests/sec
- Lock waits
- Blocking sessions
- Deadlocks/sec
- Average transaction duration
- Long-running transactions
- Log flushes/sec
- WRITELOG waits
- Page latch contention
- Key lookup frequency
- Row lock escalation
- Page lock escalation
- Table lock escalation
- Temp table usage
- Isolation level usage
- Snapshot isolation version store usage
- Connection pooling behavior
- Failed transactions
- Timeout events
- Login timeouts
- Query timeouts
- OLTP workload latency
- OLTP throughput
- Hot tables
- Hot indexes
- Hot pages

===============================================================================
21. OLAP / REPORTING / ANALYTICS TELEMETRY
===============================================================================

Collect reporting and analytical workload metrics.

- Long-running analytical queries
- Large scans
- Columnstore rowgroup health
- Columnstore deleted row percentage
- Batch mode usage
- Memory grants
- Tempdb spills
- Sort spills
- Hash spills
- Parallelism usage
- Tempdb usage
- Reporting job duration
- SSRS report execution time
- SSRS failures
- Cube processing status
- Partition processing time
- Data refresh latency
- Aggregation usage
- Statistics freshness
- Read-only replica routing
- Snapshot/reporting DB freshness
- OLAP workload CPU
- OLAP workload memory
- OLAP workload IO
- Report subscription failures
- Report rendering duration

===============================================================================
22. REPLICATION TELEMETRY
===============================================================================

Collect publisher, distributor, subscriber, and agent metrics.

- Publisher name
- Publication name
- Article list
- Distributor name
- Subscriber name
- Subscription type
- Snapshot Agent status
- Log Reader Agent status
- Distribution Agent status
- Agent last run status
- Agent latency
- Undistributed commands
- Replication errors
- Last delivered transaction
- Subscription validation status
- Article row counts
- Schema changes replicated
- Replication job failures
- Distribution database size
- Distribution cleanup status
- Log truncation blocked by replication
- Subscriber synchronization status
- Replication latency
- Replication backlog
- Replication conflict count
- Replication monitor warnings
- Replication retention configuration

===============================================================================
23. AVAILABILITY GROUP / HA-DR TELEMETRY
===============================================================================

Collect high availability and disaster recovery health metrics.

- Availability Group name
- Replica name
- Replica role
- Primary replica
- Secondary replica
- Synchronization state
- Synchronization health
- Availability mode
- Failover mode
- Listener status
- Listener DNS
- Listener IP
- Database replica state
- Log send queue
- Redo queue
- Send rate
- Redo rate
- Estimated data loss
- Estimated recovery time
- Last commit time
- HADR waits
- WSFC cluster state
- Cluster node status
- Quorum state
- File share witness status
- Cloud witness status
- Failover events
- Automatic seeding status
- Read-only routing
- Backup preference
- Replica connection errors
- AG dashboard health
- Failover readiness
- RPO compliance
- RTO compliance

===============================================================================
24. LINKED SERVER / INTEGRATION TELEMETRY
===============================================================================

Collect external dependency and linked-server telemetry.

- Linked server name
- Provider
- Data source
- Product name
- Security mapping
- RPC status
- RPC OUT status
- Collation compatible status
- Remote proc transaction promotion
- Connection encryption
- TrustServerCertificate usage
- Query timeout
- Connection timeout
- Failed linked server calls
- OLE DB waits
- Distributed transaction failures
- MSDTC dependency
- Schema drift
- Remote dependency availability
- Row count comparisons
- Cross-server query performance
- Linked server login mapping risks
- Linked server permissions

===============================================================================
25. APPLICATION CONNECTIVITY TELEMETRY
===============================================================================

Collect connection behavior and client attribution data.

- Client host name
- Application name
- Login name
- Database name
- Connection count by application
- Connection count by host
- Connection count by login
- Failed login by application
- Failed login by host
- Connection timeout errors
- TLS negotiation failures
- Kerberos usage
- NTLM usage
- SPN status
- Connection pooling behavior
- Dormant sessions
- Sleeping sessions with open transactions
- Client network waits
- Packet errors
- Network latency
- App version if available
- API service account usage
- Application dependency mapping

===============================================================================
26. DATA QUALITY AND CONSISTENCY TELEMETRY
===============================================================================

Collect data trustworthiness and source-to-target validation metrics.

- Row count baselines
- Source-target row count comparison
- Checksum comparison
- Hash comparison
- Referential integrity violations
- Duplicate key detection
- Null rate by critical column
- Invalid date patterns
- Invalid value patterns
- Failed constraints
- Disabled constraints
- Disabled triggers
- Identity gaps
- Identity exhaustion
- Sequence exhaustion
- Stale reference data
- Data freshness timestamp
- Last load timestamp
- Orphaned records
- Schema drift
- Data reconciliation status
- Data validation errors
- Business rule violations
- ETL reconciliation failures
- Source-to-target mismatch

===============================================================================
27. SCHEMA AND OBJECT TELEMETRY
===============================================================================

Collect database object inventory and change data.

- Table count
- View count
- Stored procedure count
- Function count
- Trigger count
- Synonym count
- Schema ownership
- Object create date
- Object modify date
- Recent DDL changes
- Deprecated data types
- Large object usage
- Heap tables
- Tables without primary keys
- Foreign key status
- Disabled indexes
- Disabled triggers
- Untrusted constraints
- Encrypted modules
- Cross-database references
- Three-part names
- Dynamic SQL usage
- Object dependencies
- Broken dependencies
- Invalid objects
- External tables
- PolyBase objects
- Service Broker objects

===============================================================================
28. MAINTENANCE TELEMETRY
===============================================================================

Collect maintenance execution and effectiveness data.

- Index rebuild jobs
- Index reorganize jobs
- Statistics update jobs
- CHECKDB jobs
- Backup jobs
- Cleanup jobs
- History purge jobs
- Maintenance plan history
- Maintenance duration
- Maintenance overlap
- Failed maintenance tasks
- Maintenance window compliance
- Fragmentation before maintenance
- Fragmentation after maintenance
- Statistics sampled/fullscan status
- Job schedule drift
- Maintenance exclusions
- Rebuild impact on log
- Rebuild impact on tempdb
- Maintenance success rate
- Maintenance SLA compliance

===============================================================================
29. MSDB TELEMETRY
===============================================================================

Collect MSDB operational health metrics.

- MSDB size
- Backup history row count
- Job history row count
- Database Mail row count
- Unsent mail count
- Failed mail count
- SSIS history volume
- Maintenance plan history
- Log shipping history
- Suspect pages table
- Restore history
- Operator history
- SQL Agent metadata consistency
- MSDB backup status
- MSDB growth rate
- MSDB cleanup job status
- MSDB performance impact

===============================================================================
30. DATABASE MAIL / ALERTING TELEMETRY
===============================================================================

Collect notification and alert delivery health.

- Database Mail enabled
- Mail profile status
- SMTP server
- SMTP port
- SMTP security settings
- Unsent mail count
- Failed mail count
- Last mail sent time
- Mail queue status
- Operator email
- SQL Agent alert mapping
- Severity alerts
- Job failure alerts
- Disk alerts
- Backup alerts
- Security alerts
- Database Mail XPs status
- Mail delivery latency
- Alert delivery success
- Alert routing group
- Notification tier
- Escalation path

===============================================================================
31. ERROR LOG AND EVENT LOG TELEMETRY
===============================================================================

Collect SQL Server and Windows event signals.

- SQL error log critical errors
- Severity 17 errors
- Severity 18 errors
- Severity 19 errors
- Severity 20 errors
- Severity 21 errors
- Severity 22 errors
- Severity 23 errors
- Severity 24 errors
- Severity 25 errors
- Login failures
- Deadlock graphs
- I/O warnings
- Backup failures
- DBCC errors
- AG failover events
- Replication errors
- Stack dumps
- Non-yielding scheduler events
- Memory pressure messages
- CLR app domain unloads
- Windows system errors
- Windows application errors
- Windows security log events
- Service control events
- Disk errors
- Network errors
- Certificate errors
- Kerberos errors
- SPN errors

===============================================================================
32. CAPACITY PLANNING TELEMETRY
===============================================================================

Collect trend and forecasting data.

- Database growth rate
- Data file growth
- Log file growth
- Table growth
- Index growth
- Backup growth
- Tempdb growth
- Disk free trend
- CPU trend
- Memory trend
- IOPS trend
- User growth
- Query volume trend
- ETL duration trend
- Retention consumption
- Forecasted exhaustion date
- Storage growth by database
- Storage growth by table
- Archive growth
- Reporting workload growth
- Backup repository growth
- License capacity
- Compute capacity
- Cloud cost trend where applicable

===============================================================================
33. COMPLIANCE / BASELINE DRIFT TELEMETRY
===============================================================================

Collect governance and baseline compliance signals.

- SQL version compliance
- SQL CU compliance
- OS compliance
- TLS compliance
- TDE compliance
- Backup encryption compliance
- CHECKDB compliance
- Backup RPO compliance
- Restore test compliance
- SA disabled compliance
- Sysadmin membership compliance
- Service account compliance
- gMSA compliance
- RBAC compliance
- xp_cmdshell compliance
- CLR compliance
- Database owner compliance
- TRUSTWORTHY compliance
- Public role permissions
- Guest user enabled status
- SQL Agent proxy compliance
- Audit enabled compliance
- Password policy compliance
- Firewall compliance
- Port compliance
- Antivirus exclusion compliance
- Standard configuration drift
- NIST control mapping
- CJIS control mapping
- DISA STIG mapping
- Policy exception tracking
- Remediation status

===============================================================================
34. PATCH AND CHANGE MANAGEMENT TELEMETRY
===============================================================================

Collect patching, change, and validation metrics.

- SQL build before patch
- SQL build after patch
- SQL CU level
- Windows patch level
- Pending reboot
- Patch window
- Patch success/failure
- Failed KBs
- Services restarted
- SQL Agent jobs resumed
- AG failover readiness
- Backup before patch
- Restore point before patch
- Snapshot before patch
- Application smoke test result
- Tanium status
- Change ticket/reference
- Patch compliance status
- Patch exception status
- Rollback status
- Post-patch validation result
- SQL error log after patch
- Windows event log after patch

===============================================================================
35. PERFORMANCE COUNTERS TO COLLECT
===============================================================================

SQL Server counters:
- Batch Requests/sec
- SQL Compilations/sec
- SQL Recompilations/sec
- Page life expectancy
- Buffer cache hit ratio
- Lazy writes/sec
- Page reads/sec
- Page writes/sec
- Memory grants pending
- Target server memory
- Total server memory
- Full scans/sec
- Index searches/sec
- Page splits/sec
- Forwarded records/sec
- Lock waits/sec
- Deadlocks/sec
- Lock timeouts/sec
- Transactions/sec
- Log bytes flushed/sec
- Log flush waits/sec
- User connections
- Processes blocked
- Plan cache hit ratio
- Cache pages
- Wait statistics by category
- Errors/sec by severity
- Log send queue
- Redo queue
- Backup throughput
- Columnstore rowgroup metrics

Windows counters:
- Processor % Processor Time
- Processor Queue Length
- Available MB
- Pages/sec
- Page Faults/sec
- Avg Disk sec/read
- Avg Disk sec/write
- Disk Reads/sec
- Disk Writes/sec
- Disk Transfers/sec
- Network Bytes/sec
- Packet errors
- Retransmits
- Context switches/sec
- System calls/sec
- SQL Server process CPU
- SQL Server process memory
- SQL Server process handles
- SQL Server process threads
- Logical disk free space
- Disk queue length

===============================================================================
36. REAL-TIME SESSION TELEMETRY
===============================================================================

Collect real-time active session and request data.

- Session ID
- Login name
- Host name
- Program name
- Database name
- Command
- Status
- Wait type
- Wait resource
- Blocking session ID
- CPU time
- Logical reads
- Physical reads
- Writes
- Tempdb allocation
- Open transaction count
- Percent complete
- Query text
- Execution plan
- Login time
- Last request time
- Isolation level
- Transaction state
- Row count
- Granted query memory
- Scheduler ID
- Request start time

===============================================================================
37. BLOCKING AND DEADLOCK TELEMETRY
===============================================================================

Collect concurrency and transaction conflict data.

- Blocking session ID
- Head blocker
- Blocked session count
- Blocking duration
- Blocked query text
- Blocking query text
- Lock resource
- Lock mode
- Isolation level
- Open transaction time
- Deadlock graph
- Deadlock victim
- Deadlock frequency
- Application involved
- Login involved
- Host involved
- Object involved
- Index involved
- Transaction name
- Lock escalation events
- Blocking chain history

===============================================================================
38. CLOUD / HYBRID TELEMETRY
===============================================================================

Collect cloud and hybrid platform metrics where applicable.

- Cloud resource ID
- Subscription ID
- Resource group
- Region
- VM size
- Managed disk type
- Disk IOPS limit
- Disk throughput limit
- DTU usage
- vCore usage
- Elastic pool usage
- Backup retention
- Geo-replication status
- Private endpoint status
- Firewall rules
- Defender alerts
- Key Vault integration
- Managed identity usage
- Cloud cost telemetry
- Reserved capacity
- Availability zone
- Replication region
- Cloud backup status
- Cloud security posture

===============================================================================
39. BUSINESS AND OWNERSHIP TELEMETRY
===============================================================================

Collect operational ownership data.

- Application name
- Application owner
- DBA owner
- Business owner
- Business criticality
- RTO
- RPO
- Maintenance window
- SLA
- Data classification
- Compliance scope
- Vendor contact
- Support contract
- Decommission status
- Migration status
- Modernization roadmap status
- Cost center
- Department
- Escalation contact
- On-call group
- Business impact description

===============================================================================
40. RECOMMENDED DBAOPS COLLECTION LAYERS
===============================================================================

A serious DBAOps telemetry platform should collect data in layers:

1. Inventory layer
   - What exists.

2. Configuration layer
   - How it is configured.

3. Health layer
   - Whether it is running correctly.

4. Performance layer
   - How it is behaving.

5. Security layer
   - Whether it is safe and compliant.

6. Integrity layer
   - Whether the data is trustworthy.

7. Availability layer
   - Whether the system can survive failure.

8. Capacity layer
   - Whether resources are sufficient.

9. Change layer
   - What changed and when.

10. Business layer
   - Who owns it and why it matters.

===============================================================================
41. HIGH-PRIORITY METRICS TO COLLECT FIRST
===============================================================================

If building the platform in phases, collect these first:

1. Server and SQL instance inventory
2. SQL version, edition, CU level, and OS version
3. Database list, database status, recovery model, and compatibility level
4. Max memory, MAXDOP, CTFP, and optimize for ad hoc workloads
5. CPU, memory, disk latency, and disk free space
6. Wait statistics deltas
7. Top queries by CPU, reads, duration, and writes
8. Backup status: full, differential, and transaction log
9. DBCC CHECKDB status
10. SQL Agent job failures
11. SQL Server services and Windows services
12. Failed logins and sysadmin membership
13. TDE and encryption status
14. Index fragmentation, missing indexes, and unused indexes
15. Tempdb usage and contention
16. Blocking and deadlocks
17. Replication health where applicable
18. Availability Group health where applicable
19. ETL / SSIS health where applicable
20. Patch and compliance drift
21. Database Mail and alerting health
22. Storage growth and forecasted exhaustion

===============================================================================
42. SUGGESTED DBAOPS TELEMETRY DOMAINS
===============================================================================

Organize the platform into these telemetry domains:

1. Inventory
2. Configuration
3. Security
4. Compliance
5. Performance
6. Waits
7. Queries
8. Indexes
9. Storage
10. TempDB
11. Backups
12. Integrity
13. HA/DR
14. Replication
15. ETL
16. OLTP
17. OLAP
18. Services
19. Jobs
20. Alerts
21. Patching
22. Capacity
23. Data Quality
24. Change Tracking
25. Business Ownership

===============================================================================
43. EXECUTIVE SUMMARY
===============================================================================

A DBA-administered environment should collect telemetry from every layer that can affect database trustworthiness:

- Infrastructure
- Operating system
- SQL instance
- Databases
- Security
- Permissions
- Encryption
- Backups
- Restores
- ETL pipelines
- OLTP workload
- OLAP workload
- Replication
- HA/DR
- Jobs
- Services
- Waits
- CPU
- Memory
- Storage
- Indexes
- Pages
- Query plans
- Data quality
- Patching
- Compliance
- Business ownership

The goal is not only to know whether SQL Server is up.

The goal is to know:

- Is it secure?
- Is it optimized?
- Is it consistent?
- Is it compliant?
- Is it recoverable?
- Is it integrated correctly?
- Is the data trustworthy?
- Is performance stable?
- Are services running?
- Are jobs succeeding?
- Are backups restorable?
- Are changes controlled?
- Are risks visible before they become incidents?

For DBAOps, this telemetry becomes the foundation for a centralized Database Operations Monitoring Center that can support security governance, performance engineering, compliance reporting, executive visibility, and automated remediation.
