TencentDB for SQL Server supports two deployment architectures: single-node and dual-node. This document describes the single-node architecture.
Supported Versions
SQL Server 2008 R2,2012,2014,2016,2017,2019,2022 Enterprise.
Architecture
The single-node adopts a single-node deployment method, offering extremely high cost effectiveness. Its features are highlighted below:
Supports computation-storage separation. If a compute node fails, fast recovery can be achieved by switching to another node. Underlying data is stored in three copies on cloud disks, ensuring a certain level of data reliability and enabling quick data restoration from disk snapshots in case of disk failures.
Offers over 20 monitoring metrics such as database connection, access, and resource usage, and supports configuring alarm policies as needed. Compared to a self-created CVM-based database, a single-node instance is more convenient and cost-effective, saving on expenditure. Deployed on a CVM instance, it also provides better database performance than a user-built one.
The single-node uses high-performance cloud disks as the underlying storage medium, suitable for 90% of I/O scenarios, providing high quality at a low price with stable performance.
Note
The single-node is suitable for personal learning, ISV software for small and medium-sized enterprises (such as finance, CRM, ERP clients), web applications, non-core small systems, and test environments.
As the single-node adopts a single-node architecture, when the node fails, it takes a slightly longer time to recover than a CVM instance (due to instance startup and data restoration).
For businesses requiring high availability, it is recommended to use dual-node (formerly high-availability and cluster edition) instances.
