This document describes the features and differences of TencentDB for SQL Server editions.
< tr >
Module | Feature | Two-Node (Formerly High-Availability/Cluster Edition) | Single-Node (Formerly Basic Edition) |
2008 R2 Enterprise 2012 Standard/Enterprise 2014 Standard/Enterprise 2016 Standard/Enterprise 2017 Standard/Enterprise 2019 Standard/Enterprise |
2008 R2 Enterprise 2012 Enterprise 2014 Enterprise 2016 Enterprise 2017 Enterprise 2019 Enterprise | ||
Lifecycle | Instance creation | Supported | Supported |
Instance restart | |||
Auto-renewal | |||
Billing mode modification | |||
Instance termination | |||
Read-only instance creation | |||
Publish/Subscribe | |||
Specification upgrade/downgrade | |||
Disk capacity adjustment | |||
Version upgrade | |||
Architecture upgrade | |||
Instance attribute | Instance list view | Supported | Supported |
Instance details view | |||
Instance renaming | |||
Instance remarks modifying | |||
Instance tagging | |||
Maintenance time management | |||
Project management | |||
Application availability | High availability method | Compute node migration + disk snapshot | |
Cross-AZ disaster recovery | Supported | Unsupported | |
Intra-region disaster recovery | Supported | Unsupported | |
Read-only instance removal | Supported | Unsupported | |
Cross-AZ migration | Supported | Unsupported | |
Backup and recovery | Full backup | Supported | Supported |
Data backup | |||
Increment backup | |||
Log backup | |||
Scheduled backup | |||
Manual backup | |||
Archive file | |||
Unarchived files | |||
Instance backup | |||
Multi-database backup | |||
Backup policy customization | |||
Restoration by backup set | |||
Restoration by time point | |||
Restoration by user backup set | |||
Rollback to current instance | |||
Rollback to existing intra-region instance | |||
Rollback to existing cross-region instance | |||
Backup download | |||
Backup task execution on replica instance | Unsupported | ||
Monitoring and alarms | Resource monitoring | Supported | Supported |
Engine monitoring | Supported | ||
Second-level monitoring | Unsupported (one-minute granularity) | ||
Monitoring policy customization | Unsupported | Supported | |
Alarm | Supported | Supported | |
Account management | Account creation and deletion | Supported | Supported |
Standard account | |||
Privileged account | |||
Designated account | |||
Admin Account | Unsupported | Supported | |
Database management | Database creation | Supported | Supported |
Database deletion | |||
Database cloning | |||
Database authorization | |||
Change data capture (CDC) | |||
Change tracking (CT) | |||
Database shrinking | |||
Data security | Security group | Supported | Supported |
Database audit | Unsupported currently | Unsupported | |
Network encryption | |||
TDE | Supported | ||
Data channel | Data sync | Unsupported currently | Unsupported currently |
Homogeneous data migration | Supported | Supported | |
Heterogeneous data migration | Unsupported | Unsupported | |
Publish/Subscribe | Supported | ||
Log management | Error log | Unsupported | Unsupported |
Slow log | Supported | Supported | |
Execution log | Unsupported | Unsupported | |
Blocking and deadlock events< | SQL Server 2012/2014/2016/2017/2019 Enterprise supported | SQL Server 2012/2014/2016/2017/2019 Enterprise supported | |
Parameter management | Parameter update | Supported | Supported |
Parameter history | |||
Parameter template | Unsupported | Unsupported | |
Performance optimization | Expert service | Supported | Supported |
Resource analysis | Unsupported | Unsupported | |
Engine analysis | |||
Network | Classic network | Supported | Supported |
VPC | |||
Public network address | Supported | Supported |
Was this page helpful?