ApexSQL DBA features 2016

ApexSQL DBA features - periodic table

Performance

Baselining
Wait stats
Deadlock analysis
Slowest queries
Alerts
Server info
Custom metrics
Maintenance periods
Query performance
Query waits
Execution plan
Database status
Metric history
VM monitoring
System monitoring
Server monitoring
Health monitoring

Auditing

Repository
Fault tolerance
Select auditing
Audit reports
Security auditing
Tamper resistance
Operation filter
Customizable reports
Alerts
Activity auditing
Statement auditing
Login auditing
Before and after

Backup

Policy management
Backup validation
Log shipping
Restore scheduling
Centralized management
Agent deployment
Archive history
Email notifications
Backup scheduling
Point-in-time restores
Backup history

Restore

Backup restores
Transaction log restores
Point-in-time
Compressed backup support
Instant/virtual restore

Job management

Job status
Alerts
Job chaining
Job summary
Calendar view

Database defrag

Fragmentation analysis
Index defragmentation
Job scheduling
Fill factor management
Resource management

Disaster recovery

Data recovery
Blob extraction
Schema restore
Truncate restore
Drop table restore
Undelete

Script propagation

Multi-database execution
Script list management

Execution plan

Estimated and actual query plan
Join diagram
Multiple documents support
Query parameters
Plan tree

Transaction log reading

Row history
Before and after
Undo and redo
Transaction isolation
Operation details
DDL details

* Some listed products and features are planned for 2017

 

December 16, 2015