This document introduces the feature overview and differences of various TencentDB for SQL Server editions.
Feature Overview and Differences for Various Editions
Module | Feature | Two-node (formerly High Availability and Cluster Edition) | Single-node (formerly Basic Edition) |
Version | - | 2008R2 Enterprise 2012 Standard/Enterprise 2014 Standard/Enterprise 2016 Standard/Enterprise 2017 Standard/Enterprise 2019 Standard/Enterprise 2022 Enterprise | 2008R2 Enterprise 2012 Enterprise 2014 Enterprise 2016 Enterprise 2017 Enterprise 2019 Enterprise 2022 Enterprise |
Lifecycle | Creating an instance | Supported | Supported |
| | | Restarts an instance |
| | | Auto-renewal |
| | | Changing Billing Mode |
| | | Terminate an instance |
| | | Create a read-only instance |
| | | Publish/Subscribe |
| | | Upgrading/Downgrading Specifications |
| | | Disk Expansion/Reduction |
| | | Version upgrade |
| | | Architecture upgrade |
Instance Attributes | Viewing the list of instances | Supported | Supported |
| | | Viewing instance details |
| | | Renaming an instance |
| | | Modifying instance remarks |
| | | Setting Instance Tag |
| | | Managing Maintenance Time |
| | | Project Management |
Service availability | High Availability Methods | Versions SQL Server 2008 R2/2012/2014/2016 Enterprise and SQL Server 2012/2014/2016 Standard adopt Mirror HA version SQL Server 2017/2019/2022 Enterprise adopts Always On high availability | Compute Node Migration + Disk Snapshot |
| Cross-AZ Content Disaster Recovery | Supported | Not supported |
| Intra-region disaster recovery | Supported | Not supported |
| Removing Read-Only Instances | Supported | Not supported |
| Migrating across AZs | Supported | Not supported |
Backup and Restoration | Full backup | Supported | Supported |
| | | Data Backup |
| | | Incremental backup |
| | | Log backup |
| | | Scheduled Backup |
| | | Manual Backup |
| | | Packaging Backup |
| | | Single-Database Backup |
| | | Instance Backup |
| | | Multi-Database Backup |
| | | Custom Backup Policy |
| | | Restore by Backup Set |
| | | Restore by Point-in-Time |
| | | Restore by User Backup Set |
| | | Rollback to Current Instance |
| | | Rollback to Existing Instance (Same Region) |
| | | Rollback to Existing Instance (Cross-Region) |
| | | Backup Download |
| Executing Backup Task for Instance | Versions SQL Server 2008 R2/2012/2014/2016 Enterprise, SQL Server 2012/2014/2016 Standard not supported Versions SQL Server 2017/2019/2022 Enterprise supported | Not supported |
Monitoring and Alarms | Resource Monitoring | Supported | Supported |
| | Engine monitoring | Supported |
| | Second-level monitoring | Not supported (1-minute granularity) |
| Custom Monitoring Strategy | Not supported | Supported |
| Alarm Metrics | Supported | Supported |
Account management | Creating and Deleting Accounts | Supported | Supported |
| | | Standard account |
| | | Privileged account |
| | | Special Permissions Account |
| Privileged Account | Not supported | Supported |
Database management | Create a database | Supported | Supported |
| | | Dropping a Database |
| | | Cloning Database |
| | | Database Authorization |
| | | Setting Change Data Capture (CDC) |
| | | Setting Change Tracking (CT) |
| | | Shrinking Database |
Data security | Security Group | Supported | Supported |
| Database Audit | Not supported yet | Not supported |
| | | Network Encryption |
| TDE Encryption | Supported | Supported |
| SSL encryption | Supported | Supported |
Data channel | Data sync | Not supported yet | Not supported yet |
| Homogeneous Data Migration | Supported | Supported |
| Heterogeneous Data Migration | Not supported | Not supported |
| | Publish/Subscribe | Supported |
Log management | Error Log | Not supported | Not supported |
| Slow Logs | Supported | Supported |
| Viewing running logs | Not supported | Not supported |
| Blocking and Deadlock Events | Versions SQL Server 2012/2014/2016/2017/2019/2022 Enterprise supported | Versions SQL Server 2012/2014/2016/2017/2019/2022 Enterprise supported |
Parameter management | Parameter Update | Supported | Supported |
| | | Parameter History |
| Parameter Template | Not supported | Not supported |
Performance | Expert Service | Supported | Supported |
| Resource analysis | Not supported | Not supported |
| | | Engine Analysis |
Network | Classic Network | Supported | Supported |
| | | Virtual Private Cloud (VPC) |
| Public Network Address | Supported | Supported |