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
|
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