Know your SQL Servers are backed up, healthy and not running out of space.
DataBridge ships six SQL Server tools: Backup Manager, Health Monitor, Space Monitor, Index Advisor, Query Analyzer and Security Auditor. Each has its own dashboard and schedule.
Small IT teams run SQL Servers for the ERP and a dozen other apps. Backups, disk space and slow queries need watching, and the expensive tools are built for a full-time DBA.
Modules. Database module.
Edition. DataBridge Server. Desktop does not include the SQL Server tools.
A real DataBridge screen, with sample data from a demo instance.
How DataBridge does it.
Each step names the feature as it appears in the product.
- Step 1
Connection
Add a connection to the SQL Server. Each module needs the Database module and one connection.
- Step 2
Backup Manager
Runs full, differential and log backups with native T-SQL BACKUP statements, verifies them and lists them per database.
- Step 3
Health Monitor
Reads the server's diagnostic views on a schedule and records a score, findings and metrics.
- Step 4
Space Monitor and Index Advisor
Track database and file growth and disk space. Index Advisor analyzes fragmentation and missing indexes and has maintenance windows.
- Step 5
Query Analyzer and Security Auditor
Rank queries by CPU, I/O and duration and check plan cache use. Review logins, roles, orphaned users and best-practice findings.
- Step 6
Schedules and alerts
One background sweep checks every module's schedule once a minute by default. Open alerts are emailed once the server's email is set up.
What this does not do.
- These tools work with SQL Server only, not PostgreSQL or MySQL.
- Each module needs permissions on the server, and the app provides a permission script. Give the monitoring login only what it needs.
- Some actions, such as rebuilding an index, change the server. Read the dashboard before you click.
Marketplace packs used: SQL Server Backup Manager, SQL Server Health Monitor, SQL Server Space Monitor, SQL Server Index Advisor, SQL Server Query Analyzer, SQL Server Security Auditor. See the Marketplace.
Related pages.
Try the parts that are free today.
The free browser edition needs no sign-in and never uploads your files.