SQL Server diagnostics. built for support teams.

Database first aid

for omnicore dispatch

omniMedic is a single portable executable that lets any engineer check an omnicore dispatch SQL Server's health and safely fix what's wrong – with a full audit trail and nothing to install.

SEE DISPATCH OPTIONS

Why It Exist

omnicore dispatch databases grow, fragment and fill disks. Fixing that has always meant a scarce specialist, a risky manual procedure and time logged into a customer's live server.

omniMedic turns that work into guarded, one-click actions that any engineer can run confidently – the safe queries are built in and signed, the dangerous ones are wrapped in guardrails and everything is recorded. Copy one file to the server and go.

The Shortlist

Top 10 Capabilities that Move the Needle

Ranked by the difference they make to a business – faster resolution, less risk, lower cost and expertise that scales beyond your specialists.

01 One-click Health Report

Runs every read-only check and returns a severity-ranked, one-page verdict – with the exact next step for each finding and a "Fix it" button that jumps straight to it.

Anyone can triage a struggling database in under a minute instead of escalating and waiting for a specialist to log in.

02 Catastrophe-proof destructive operations

Every TRUNCATE or bulk DELETE passes through a guardrail: a blast-radius preview (row counts, incoming foreign keys, the exact SQL), a typed "I UNDERSTAND", a live disk-space floor and an audit entry.

Removes the single biggest cause of self-inflicted data-loss incidents – the accidental wipe of the wrong table on the wrong server.

03 Reclaim disk space safely on very large databases

Purpose-built shrink for big omnicore dispatch databases – a fast TRUNCATEONLY pass, an incremental stepped shrink with a live ETA and index rebuilds to undo the fragmentation shrinking causes.

Recovers storage and defers a hardware purchase without a blind, hours-long operation that might fill the disk it's trying to free.

04 Rapid Clean + Index – a maintenance window in one button

Collapses the full manual reset – purge activity logs & location history, then shrink → rebuild → shrink → rebuild – into one guarded, supervised orchestration with a running log.

Turns a half-day procedure into a repeatable, supervised click, so scheduled maintenance stops eating an engineer's afternoon.

05 Signed Query Library – expert knowledge, safely bottled

A curated set of diagnostic, clean-up and repair queries, each cryptographically signed. Read / write / destructive modes are enforced, and a tampered or unverified pack automatically disables every dangerous query.

Any engineer runs vetted, senior-level operations safely – the right query, version-controlled and verified, instead of ad-hoc SQL pasted from a wiki.

06 Zero-install, single portable executable

One self-contained .exe with the runtime bundled in. Copy it to the server, run it, close it – nothing is installed and no footprint is left behind.

Works in locked-down, regulated and air-gapped environments where you can't install software, and gets an engineer productive on-site in seconds.

07 Telemetry bundle + offline Analyzer

Capture diagnostics, the health report and system information into a single portable .zip, then open and inspect it on any machine with the built-in Analyzer – no live connection required.

Escalations move faster and off the production box: senior staff diagnose from the bundle instead of needing their own session on a customer's live server.

08 Live progress and ETAs on every long operation

Shrinks, index rebuilds and batched deletes show a gliding progress bar, a genuine time-remaining estimate and a Stop button that halts safely at the next checkpoint.

Maintenance windows become predictable – you can tell a customer how long it will take and stop cleanly if you run out of time, instead of watching a frozen screen.

09 Safe by default

Read-only until you deliberately opt in; encryption-aware connections; passwords held only in memory, never written to disk; a disk floor that auto-aborts; and elevation that is recommended but never forced.

Hard to misuse, so it's safe to put in more hands – the defaults protect the database and the operator alike.

10 Complete, portable audit trail

Every write and destructive action is logged with what ran, where and when, and can be packaged straight into a support bundle.

A defensible record for compliance, handover and incident review – you always know exactly what was done to a customer's database, and by which operation.

Preview · loops automatically
How the Health Report canvas fills while the check runs. An ECG vital-signs trace, a live progress bar and a checklist ticking through each probe from pending → scanning → done. This is a faithful mock; the real panel runs inside omnicore dispatch.

Scanning omnicore

Starting…

0 of 7 checks complete

The Bottom Line

What omniMedic is Worth to the Business

Six outcomes that show up in resolution times, incident counts and budgets.

Resolve faster

One-click diagnostics and guided fixes cut mean-time-to-resolution and let front-line staff act without waiting on a specialist.

Scale expertise

Signed queries and guided fixes bottle senior-DBA knowledge so a much larger team can work safely – no bottleneck on scarce specialists.

Cut risk

Guardrails and a full audit trail prevent the accidental data-loss and disk-full incidents that cost the most to recover from.

Fit anywhere

Portable and install-free, it runs in regulated, disconnected and air-gapped environments, and analyzes captured bundles offline.

Spend less

Reclaim storage to defer hardware, and resolve more on the first touch – fewer specialist escalations and shorter engagements.

Built for omnicore dispatch

Not a generic SQL tool – it knows the omnicore dispatch schema (activity logs, location history, teams) so its checks and clean-ups are targeted and correct.

Everything in the Box

The Full Feature Set

Organized by what you're doing: understand the database, act on it, stay protected and hand off cleanly.

Diagnose

Health Report - One-page, severity-ranked verdict with a fix for each finding; live vital-signs scan while it runs.
Fix-it deep-links - Jump from a finding straight to the exact remedy – right tab or pre-selected query.
Diagnostics - Active & blocked queries, top slow queries, table sizes, index space hogs, server / edition read-out.

Operate

Signed Query Library - Curated read / write / destructive queries, cryptographically verified.
Custom Query - Ad-hoc SQL, read-only by default with an explicit write mode.
Maintenance - Index reorganize / offline rebuild, large-DB shrink, update statistics, disk overview.
Rapid Clean + Index - Guarded 6-step one-click reset for a maintenance window.

Protect

Heavy Guardrail - Blast-radius preview, typed confirmation, batched runner, session limit, safe Stop.
DiskGuard - Pre-flight and mid-run disk-floor checks that auto-abort before a volume fills.
Verified-pack gating - Unsigned or tampered query packs disable all write / destructive actions.
Audit log - Every write / destructive action recorded; elevation is shown, never forced.

Support & portability

Telemetry bundle - Package diagnostics, health report and system info into one portable zip.
Offline Bundle Analyzer - Inspect a captured bundle on any machine – no SQL connection needed.
Single self-contained .exe - Runtime bundled; copy-and-run, nothing to install.
In-app help & guides - Context-aware help plus bundled Manual and Release-notes PDFs.

Who it's for

Anyone who has to keep an omnicore dispatch database healthy

Front-line support engineers and field technicians
IT operations and system administrators at customer sites
Database administrators who want a fast, guarded toolkit
Senior / escalation staff triaging from a captured bundle

In Practice

Connect & scan. Copy the file to the server, connect and run the Health Report – a ranked verdict in under a minute.
Fix with one click. Follow a "Fix it" button to the exact clean-up or maintenance action, run behind its guardrail.
Capture & hand off. Bundle the results for the ticket, with the full audit trail attached. Nothing installed, nothing left behind.

Availability

Rolling out from September 2026

omniMedic is available at no additional cost for selected omnicore dispatch deployments on an active, current omnicare plan. If your organization runs omnicore dispatch and would like early access, contact your Omnitronics account manager or log a ticket with support to see if you're eligible.

Get in Touch