Heads up: this demo is actively under development. Chat isn’t fully configured yet and View History may be limited or change. Thanks for trying it out—feedback is welcome!
ZeroDBA Demo
Hands-on demo: paste diagnostics, explore unified accordion results, and chat with ZeroBot for guided SQL Server fixes.
1. Paste diagnostics
Drop in JSON from your collector or use the demo payload.
2. Review findings
Unified accordion shows What/Why/Verify/Fix once—no duplicates.
3. Copy or ask
Copy T-SQL directly or ask ZeroBot to explain and harden scripts.
Are we missing any checks?
Here are a few common items teams often add on top of the baseline. If any of these fit your environment, we can fold them into the analyzer.
Instance & Engine
- Max Server Memory cap sanity (by host RAM / co-resident services)
- MAXDOP cap aligned to cores/NUMA and vendor guidance
- Optimize for Ad Hoc Workloads (reduce single-use plan bloat)
- Backup compression default and model database template settings
- Trace flags / database-scoped configs (optimizer hotfixes, ADR)
- Query Store configuration and read/write status per DB
Storage & TempDB
- Instant File Initialization (data file zeroing)
- Filegrowth settings in MB (no percent) for data/log
- Excessive VLF count on transaction logs
- TempDB file placement and latency outliers
Reliability & Jobs
- Agent Operators + Database Mail health (alerts actually notify)
- Job failure trend / last failures (top offenders)
- Integrity checks coverage (system DBs, very large DB scheduling)
- Restore testing evidence / last verified restore
Security & Compliance
- Public role permissions drift and unsafe grants
- Logins in
sysadmin(non-service accounts) & SA status - TLS/encryption in-transit, Force Encryption, and certificate age
- TDE / backup encryption adoption
- TRUSTWORTHY OFF where not explicitly required
- CLR strict security and external access policies
Tip: copy your notes above and paste them into the feedback document so we can track them.