ApexSQL DBA features 2017

ApexSQL DBA features - periodic table

Performance
monitoring

Baselining
Wait stats
Deadlock analysis
Slowest queries
Alerts
Server info
Custom metrics
AlwaysOn monitoring
Maintenance periods
Query performance
Query waits
Execution plan
Database status
Metric history
Failover cluster
instance monitoring
VM monitoring
System monitoring
Server monitoring
Database monitoring
Health monitoring
Index monitoring
Server grouping
Custom charts
Integration Services
monitoring
Analysis Services
monitoring
Package performance
Cube performance
Reporting Services
monitoring

Auditing &
compliance

Repository
Fault tolerance
Select statement
auditing
Out-of-the-box reports
Forensic auditing
Tamper resistance
Security auditing
Full row history
Customizable reports
Alerts
Activity auditing
Statement auditing
Login auditing
Before and after
auditing
Transaction isolation
Transaction details
Schema change
auditing
Compliance reports
Health information
Retention policies

Disaster recovery

Data recovery
Blob extraction
Schema change
reversal
Truncated data restore
Dropped table restore
Undo and redo
Transaction isolation
Transaction reversal
Undelete

Execution plan exploring

Query expressions
Estimated and actual query plan
Join diagram
Multiple documents support
Query parameters
Execution plan XML
Live execution plans
Query performance analysis
Query store analysis
Execution plan history
I/O by table

Job management

Job status
Alerts
Job chaining
Job summary
Calendar view
Server documentation
Server discovery
Inventory management
Server reports

Defragmentation

Fragmentation analysis
Index defragmentation
Job scheduling
Defragmentation
thresholds
Fill factor management
Resource management

Security

Security risk analysis
Sec. vulnerabilities detection
Security policies
User permissions analysis

Backup

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

Virtual restore

Backup restore
Forensic auditing
Drill down
Transaction log restore
Point-in-time restore
Compressed backup support
Instant/virtual restore

Script propagation

Multi-database execution
Script list management
Pre-execute script parsing
Results exports

* Some listed products and features are planned for 2017

 

January 6, 2017