A Complex Tool
Features
Scope: MS SQL Server 2008 – 2019.
Scope: Oracle 12c – 19c
All you need to know
Reports
Reports
Configuration
- DCMS Checks
General configurations check
- Best Practice Configuration
Verification of multiple best practices recommended by Microsoft
- Transaction Logs
Presents size of transaction logs and verifies they are smaller than data
- Instance Jobs
Verifies if instance jobs have failure emails set and if their owner is disabled
- Index Fragmentation
Provides information on index fragmentation and verifies whether instance indexes are not overly fragmented
- Tempdb Audit
Audits specific to the tempdb database, including its best practices and transaction log size
Security
- Instance Version Summary
Verifies if the current instance version is up to date
- Unlocked SA Accounts
Verifies whether SA account exists and if it is enabled
- Sysadmin Accounts
Lists all sysadmin accounts on the instance and informs you if they are enabled
- Orphaned Users
Verifies if orphaned users exist and lists them
- Elevated DB Permissions
Lists all users with high privilege database roles
Logs
- Instances History Jobs Status
Listing of jobs that finish with errors
- Instances Error Status
Highlights of important errors (level 16 or above)
- Instances Replication Status
Listing of replication errors, publisher databases and publication and subscription statuses
- Failed Logins Status
Lists occurences of repeated unsuccessful login attempts
DB Level
- Database Backups
Raises awareness about databases that were not backed up in the last 48 hours (or a custom interval)
- Database Scaling
History data on the database growth
- Index Fragmentation
Presents data on fragmentation of indexes and raises warnings for high fragmentation values (above 15%)
Smart & Handy
Functions
- Configure audit frequency - set different frequencies per report and per instance severity
- Ability to scan servers from different domains
- Ability to add exceptions to reports and entries to ignore their warnings
- Send report every month - Share as Excel or CSV file
- Customizable email alerts
- Ability to add comments to nearly every entry
- Comprehensive reports to tell you whether how many monitored instances and databases failed a given audit
- SQL Server report listing versions and editions of monitored servers
Features & Benefits
Play Video
instant benefits
Use cases
End User
- Own individual databases monitoring system (cloud and on premises)
- System data kept in a single central place
- Data protection in accordance with the best practices
CLOUD PROVIDER
- Cloud databases configuration monitoring possibility as well as user recommendations generating
- Centralized database available only for the cloud provider, on the basis of which recommendations are generated
- PaaS service's quality enhancement
