tencent cloud

Feedback

Features and Differences

Last updated: 2023-07-21 17:42:25

    This document describes the features and differences of TencentDB for SQL Server editions.

    Edition Features and Differences

    < tr >

    ModuleFeatureTwo-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 creationSupportedSupported
    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 viewSupportedSupported
    Instance details view
    Instance renaming
    Instance remarks modifying
    Instance tagging
    Maintenance time management
    Project management
    Application availability High availability method
  • SQL Server 2008R2/2012/2014/2016 Enterprise, SQL Server 2012/2014/2016 Standard adopt Mirror HA
  • SQL Server 2017/2019 Enterprise adopt Always On high availability
  • Compute node migration + disk snapshot
    Cross-AZ disaster recoverySupportedUnsupported
    Intra-region disaster recoverySupportedUnsupported
    Read-only instance removalSupportedUnsupported
    Cross-AZ migrationSupportedUnsupported
    Backup and recovery Full backupSupportedSupported
    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
  • SQL Server 2008R2/2012/2014/2016 Enterprise, SQL Server 2012/2014/2016 Standard unsupported
  • SQL Server 2017/2019 Enterprise supported
  • Unsupported
    Monitoring and alarms Resource monitoringSupportedSupported
    Engine monitoringSupported
    Second-level monitoringUnsupported (one-minute granularity)
    Monitoring policy customizationUnsupportedSupported
    AlarmSupportedSupported
    Account management Account creation and deletionSupportedSupported
    Standard account
    Privileged account
    Designated account
    Admin AccountUnsupportedSupported
    Database management Database creationSupportedSupported
    Database deletion
    Database cloning
    Database authorization
    Change data capture (CDC)
    Change tracking (CT)
    Database shrinking
    Data security Security groupSupportedSupported
    Database auditUnsupported currentlyUnsupported
    Network encryption
    TDESupported
    Data channel Data syncUnsupported currentlyUnsupported currently
    Homogeneous data migration SupportedSupported
    Heterogeneous data migrationUnsupportedUnsupported
    Publish/SubscribeSupported
    Log management Error logUnsupportedUnsupported
    Slow logSupportedSupported
    Execution logUnsupportedUnsupported
    Blocking and deadlock events<SQL Server 2012/2014/2016/2017/2019 Enterprise supportedSQL Server 2012/2014/2016/2017/2019 Enterprise supported
    Parameter management Parameter updateSupportedSupported
    Parameter history
    Parameter templateUnsupportedUnsupported
    Performance optimization Expert serviceSupportedSupported
    Resource analysisUnsupportedUnsupported
    Engine analysis
    Network Classic networkSupportedSupported
    VPC
    Public network addressSupportedSupported
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support