Strengths
Last updated: 2025-05-30 10:21:04
TencentDB for SQL Server Strengths
Official License for Security Compliance
SQL Server versions from 2008R2 to 2022 are supported to meet various needs. The product is licensed by Microsoft to continuously provide users with the latest features and avoid the risks of unauthorized software use. This makes enterprises more trustworthy in competitions. The full-linkage security protection system of disk encryption + TDE + SSL + audit can protect end-to-end security, eliminate data leakage risks, and fully meet security compliance requirements.
High Performance and Elastic Scalability
Enterprise-level PCIe SSDs are used to provide industry-leading I/O throughput. The performance far exceeds that of databases built by users, supporting concurrent requests of commercial-level and high-intensity businesses. Multiple architectures (single-node/two-node/multi-node) and various specifications are provided for flexible combination. secondary nodes directly provide read-only services. In addition, instance specification adjustments and storage expansion can be completed in minutes to respond to rapid changes in business needs.
Backup for Stability and Reliability
The backup system (automatic + manual + cross-region), second-level log protection, and flexible policy configuration can achieve 99.9996% data reliability. Second-level rollback to any point in time is supported to prevent data loss. Full-linkage backup policies can be configured to flexibly meet business needs, and the backup mechanism ensures comprehensive disaster recovery. In addition, the full-linkage monitoring and intelligent cleanup mechanisms help guarantee enterprise data security and effectively control storage costs to meet strict disaster recovery requirements.
Multi-layer Disaster Recovery
The primary/secondary two-node architecture and multi-node HA architecture, based on self-developed keepalive and smart primary node election mechanisms, support second-level failover in case of failures. The service availability can reach 99.95%. Intra-city multi-AZ deployment and cross-region backup for disaster recovery are supported. To ensure high availability, 3 AZs are used for intra-city + cross-city disaster recovery to prevent business downtime. Full-linkage redundancy design from database instances to backend control systems ensures stable and uninterrupted business operation.
Smart Ops and Convenient Management
Users do not need to worry about database installation and maintenance. They can manage instances, permissions, networks, logs, backups, and monitoring through the Tencent Cloud console and SQL Server Management Studio (SSMS). Ops becomes less complex. Nearly 50 real-time metrics and custom thresholds for alarms are supported to quickly locate issues.
Business Intelligence for Deep Empowerment
The built-in SSIS + BI full-linkage analysis service covers data extraction, ETL, and visual analysis and helps enterprises explore high-value data, perform business intelligence analysis, and build a primary data management system.
TencentDB for SQL Server's strengths over self-built SQL Server
Feature | TencentDB for SQL Server | Self-Built SQL Server |
Service availability | You have to guarantee the service availability and set up primary/secondary replication and RAID capabilities on your own. | |
System security | Anti-DDoS is supported, and various database security vulnerabilities are fixed in time. The data security meets all mainstream national and international security standards. | You have to deploy security services and fix vulnerabilities on your own at high costs. Security compliance is not guaranteed, and the security requirements cannot be quickly met. |
Database performance | High-performance devices with a TPM of up to 4.5 million are used. For more information, see Performance Test Report. | General devices without optimization and fine-tuning are used. |
Software and hardware investment | No hardware or software investment is required, and the service is pay-as-you-go. | Database servers are costly. |
System hosting | There are no hosting fees. | The hosting fees are high. |
Deployment and scaling | The out-of-the-box service can be quickly deployed and elastically scaled. | You have to purchase hardware devices, host them in data centers, and deploy them on your own. You also have to solve stability problems and set up many supporting modules and management tools, which require heavy investments in technology and take a long period of time. |
Resource utilization | The service is billed by the actual usage and supports elastic scaling to ensure a high resource utilization. | You have to consider traffic spikes, and the resource utilization is low. |
Data disaster recovery | Primary/secondary replication and backup are configured by default. Both intra-region and cross-region disaster recovery schemes are supported, such as multi-AZ deployment and cross-region backup. | You have to find the backup storage space and regularly verify whether backups can be restored, which cost more money and time. |
Control and management services | Comprehensive cloud-based instance lifecycle management capabilities are available for various objects, including monitoring and alarming, backup and restoration, instance, database, account, network, parameter, and log. | You have to implement all control and management capabilities on your own. |
Procurement costs | Instances are priced transparently and even more cost-effective than CVM. | In addition to instances, you also have to set up disaster recovery, monitoring, and management systems on your own at totally uncontrollable costs. |
License | Official licenses from Microsoft continuously provide you with the latest features, eliminating your need to purchase additional licenses. | Pirated services lead to legal risks, while official licenses are expensive. |
Ops costs | Tencent Cloud provides a professional team to guarantee the service quality for key accounts 24/7, eliminating your need to manually perform Ops. | You have to hire dedicated DBAs for database maintenance, which incurs high labor costs. |
TencentDB for SQL Server's high availability/disaster recovery capabilities
TencentDB for SQL Server provides disaster recovery capabilities at different levels, including instance, server, data center, AZ, and region, to ensure the business continuity on healthy systems with the minimum data loss in case of natural disasters, device failures, and maloperations. Backup is the basis of all disaster recovery systems and the last line of defense in the high data availability architecture. TencentDB for SQL Server features rich backup capabilities, ensuring that the data can be restored quickly even after a total system crash to guarantee the business continuity as much as possible.
TencentDB for SQL Server provides instances in various architectures with guaranteed high availability:
Single-node instance (formerly Basic Edition)
It is deployed on the CVM at the bottom layer, with a separation of storage and computing. The underlying Premium Cloud Disk three-secondary storage can prevent data loss. In extreme cases, if the instance fails, a new instance will be started, and the data in the original instance will be automatically restored to the new instance through backup recovery by combining data backup and the most recent log backup. The specific recovery time depends on the size of the data volume. Typically, the servers of the two database instances are on the same physical server.
Two-node instance (formerly HA Edition and Cluster Edition)
SQL Server 2008R2, 2012, 2014, and 2016 Enterprise: The primary/secondary two-node architecture consists of one primary SQL Server database and one mirror SQL Server database in cross-rack or cross-AZ deployment mode. This provides the second-level automatic failover capability.
SQL Server 2017, 2019 Enterprise, and 2022 Enterprise: The primary-secondary two-node architecture uses the Always On technology to build a high-performance, highly available, highly reliable, and easy-to-maintain SQL Server architecture in cross-rack or cross-AZ deployment mode. This provides the second-level automatic failover capability.
Multi-node instance
The one-primary-multiple-secondary architecture of versions SQL Server 2017, 2019, and 2022 Enterprise, which uses Always On technology to build a high-performance, highly available, highly reliable, and easy-to-maintain SQL Server cluster architecture across racks/AZs, providing second-level HA automatic switch.
For intra-region disaster recovery, TencentDB for SQL Server provides multi-AZ deployment capabilities. Different AZs in the same region are interconnected over the private network, and failures can be isolated between AZs. For instances in the primary/secondary two-node architecture, the primary and secondary instances can be deployed in different AZs in the same region (for example, one primary instance in the primary AZ and one secondary instance in the secondary AZ). This improves the business continuity and guarantees the data availability in case of instance failures or AZ disconnections. You can also manually switch between the primary and secondary instances in the console to verify the business robustness. Switches within the same AZ and between different AZs are imperceptible to the application.
For remote disaster recovery, cross-region backup capabilities are offered to store backup files in another region. You can set the cross-region backup retention period and multiple backup regions. After a cross-region backup policy is enabled, the instance backup files will be automatically stored in the target region. In this way, if an instance in a region fails, you can restore its backup files in the remote region to a new instance there for guaranteed business continuity. You can also create a cross-region cluster through a cross-region read-only instance, sync data between the primary and read-only instance, switch your business to a remote read-only instance if the region of the primary instance fails. By doing so, you can implement the high availability of database restoration and meet the requirements for data availability and security, remote backup and restoration, remote disaster recovery, long-term data archive, and regulation compliance.
In addition, TencentDB for SQL Server also has rich backup capabilities to guarantee the data security and prevent data loss or corruption. Specifically, you can configure automatic backup, manual backup, data backup, log backup, backup file format (unarchived files or archive file), instance backup, and multi-database backup. You can also customize the backup policy, backup retention period (7–1,830 days), and backup cycle.
Moreover, TencentDB for SQL Server comes with comprehensive disaster recovery capabilities at both the data and business management layers. Cross-region disaster recovery for databases is meaningful only if the business also features cross-region disaster recovery. However, cross-region distributed deployment of the business inevitably causes the split-brain problem. At the business management layer, the business is deployed in three AZs (two intra-region AZs and one remote AZ) to ensure the business continuity. Before an actual failover occurs, the system will always check whether the database sync status (database sync system table) is normal to avoid faulty failover.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback