This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Overview

1: Server Types
2: Monitoring metrics

Service Overview

Microsoft SQL Server (DBaaS) is a representative relational database management system (RDBMS) used in various applications. Samsung Cloud Platform provides an environment that automates Microsoft SQL Server installation and offers management functions for operation through a web-based console.

Microsoft SQL Server (DBaaS) is designed with an Always On-based availability architecture, so when the Primary server’s content changes, it is synchronously replicated to the Secondary server. Additionally, it provides an automatic backup feature at user‑specified times to prepare for issues with the DB server or data, enabling recovery of data at a desired point in time.

Provided features

Microsoft SQL Server (DBaaS) provides the following features.

Auto Provisioning: UI allows installation and configuration of Database(DB), and provides a Primary-Secondary redundancy configuration based on Always On. When the Primary server fails, it automatically fails over to the Secondary.
Operation Control Management: Provides functionality to control the state of running servers. In addition to start and stop, restart is possible when there is a DB issue or to apply configuration changes. When configured for high availability (HA), users can manually perform node switching between Primary and Secondary via a switch‑over.
Backup and Recovery: Provides data backup functionality based on its own backup commands. Users can set the backup time window, retention organization, and Full backup day, and additional fees apply based on backup volume. It also offers a recovery function for backed‑up data, creating a separate DB when the user performs a recovery and restoring to the point in time selected by the user (backup save point, custom point). When restoring to a user‑specified point, the restore time can be set to 5 minutes/10 minutes/30 minutes/1 hour before the stored backup file and archive file.
Version Management: Provides version upgrade (Minor) functionality for certain feature improvements and security patches. Users can choose whether to perform a backup for the version upgrade, and if a backup is performed, data is backed up before applying the patch, then the DB engine is updated.
Secondary configuration: You can add a read‑only Read Replica (Secondary Replica), which expands read performance and distributes load.
Audit Settings: Provides an audit configuration feature that can monitor users’ DB access and the results of DDL (Data Definition Language)/DML (Data Manipulation Language) operations.
Parameter management: Modification of DB configuration parameters related to performance improvement and security is possible.
Service Status Query: Retrieves the latest status of the current DB service.
Monitoring: CPU, memory, DB performance monitoring information can be viewed through the Cloud Monitoring service.
DB User Management: View and manage DB account (user) information registered in the DB.
Export DB Log: You can export stored logs to the user’s Object Storage through Audit settings.

Component

Microsoft SQL Server(DBaaS) provides pre-validated engine versions and various server types. Users can select and use them according to the scale of the service they wish to configure.

Engine version

The engine versions supported by Microsoft SQL Server(DBaaS) are as follows.

Technical support can be used until the supplier’s EoTS (End of Technical Service) date, and the EOS date when new creation is halted is set to six months before the EoTS date.

Because the supplier’s policy may cause the EOS and EoTS dates to change, please refer to the supplier’s license management policy page for details.

Microsoft SQL Server: https://learn.microsoft.com/ko-kr/lifecycle/products/?terms=sql%20server

Provided version	EOS Date (Samsung Cloud Platform new creation stop date)	EoTS Date (Community technical support end date)
Microsoft SQL Server 2019 Enterprise	2029-06 (planned)	2030-01-08(Extended Support) 2025-02-28(Standard Support)
Microsoft SQL Server 2019 Standard	2029-06 (planned)	2030-01-08(Extended Support) 2025-02-28(Standard Support)
Microsoft SQL Server 2022 Enterprise	2032-06 (planned)	2033-01-11(Extended Support) 2028-01-11(Standard Support)
Microsoft SQL Server 2022 Standard	2032-06 (planned)	2033-01-11(Extended Support) 2028-01-11(Standard Support)

Table. Engine versions provided by Microsoft SQL Server(DBaaS)

Server type

The server types supported by Microsoft SQL Server (DBaaS) are as follows.

For detailed information about the server types offered by Microsoft SQL Server (DBaaS), refer to Microsoft SQL Server(DBaaS) Server Types.

Standard db1v2m4

Category	example	Detailed description
Server type	Standard	Provided server types Standard: Standard configuration (vCPU, Memory) commonly used High Capacity: Large server specifications with 24 vCores or more
Server specifications	db1	Provided server specifications db1: Standard specifications (vCPU, Memory) commonly used dbh2: Large-capacity server specifications Provides servers with 24 vCores or more
Server specifications	v2	Number of vCores v2: 2 virtual cores
Server specifications	m4	Memory capacity m4: 4GB Memory

Table. Microsoft SQL Server(DBaaS) server type components

Preliminary Service

This is a list of services that must be pre-configured before creating the service. Please refer to the guide provided for each service and prepare in advance.

Service Category	service	Detailed description
Networking	VPC	A service that provides an isolated virtual network in a cloud environment

Table. Microsoft SQL Server(DBaaS) required services

1 - Server Types

Microsoft SQL Server(DBaaS) server type

Microsoft SQL Server(DBaaS) provides server types composed of various combinations of CPU, memory, and network bandwidth. When creating a Microsoft SQL Server (DBaaS), the Database Engine is installed according to the server type selected for the intended use.

The server types supported by Microsoft SQL Server (DBaaS) are as follows.

Standard db1v2m4

Category	example	Detailed description
Server type	Standard	Provided server type classifications Standard: Configured with the commonly used standard specifications (vCPU, Memory) High Capacity: Large-capacity server specifications exceeding Standard
Server specifications	db1	Provided server type classification and generation db1: means a standard specification, and 1 indicates the generation dbh2: h indicates a high-capacity server specification, and 2 indicates the generation
Server specifications	v2	Number of vCores v2: 2 virtual cores
Server specifications	m4	Memory capacity m4: 4GB Memory

Table. Microsoft SQL Server (DBaaS) server type format

db1 server type

The db1 server type of Microsoft SQL Server(DBaaS) is provided with standard specifications (vCPU, Memory) and is suitable for various database workloads.

Intel 3rd‑generation (Ice Lake) Xeon Gold 6342 Processor up to 3.3 GHz
Supports up to 16 vCPUs and 256 GB of memory
Maximum networking speed of 12.5 Gbps

Category	Server type	vCPU	Memory	Network Bandwidth
Standard	db1v2m4	2 vCore	4 GB	Up to 10 Gbps
Standard	db1v2m8	2 vCore	8 GB	Up to 10 Gbps
Standard	db1v2m16	2 vCore	16 GB	Up to 10 Gbps
Standard	db1v2m24	2 vCore	24 GB	Up to 10 Gbps
Standard	db1v2m32	2 vCore	32 GB	Up to 10 Gbps
Standard	db1v4m8	4 vCore	8 GB	Up to 10 Gbps
Standard	db1v4m16	4 vCore	16 GB	Up to 10 Gbps
Standard	db1v4m32	4 vCore	32 GB	Up to 10 Gbps
Standard	db1v4m48	4 vCore	48 GB	Up to 10 Gbps
Standard	db1v4m64	4 vCore	64 GB	Up to 10 Gbps
Standard	db1v6m12	6 vCore	12 GB	Up to 10 Gbps
Standard	db1v6m24	6 vCore	24 GB	Up to 10 Gbps
Standard	db1v6m48	6 vCore	48 GB	Up to 10 Gbps
Standard	db1v6m72	6 vCore	72 GB	Up to 10 Gbps
Standard	db1v6m96	6 vCore	96 GB	Up to 10 Gbps
Standard	db1v8m16	8 vCore	16 GB	Up to 10 Gbps
Standard	db1v8m32	8 vCore	32 GB	Up to 10 Gbps
Standard	db1v8m64	8 vCore	64 GB	Up to 10 Gbps
Standard	db1v8m96	8 vCore	96 GB	Up to 10 Gbps
Standard	db1v8m128	8 vCore	128 GB	Up to 10 Gbps
Standard	db1v10m20	10 vCore	20 GB	Up to 10 Gbps
Standard	db1v10m40	10 vCore	40 GB	Up to 10 Gbps
Standard	db1v10m80	10 vCore	80 GB	Up to 10 Gbps
Standard	db1v10m120	10 vCore	120 GB	Up to 10 Gbps
Standard	db1v10m160	10 vCore	160 GB	Up to 10 Gbps
Standard	db1v12m24	12 vCore	24 GB	Maximum 12.5 Gbps
Standard	db1v12m48	12 vCore	48 GB	Up to 12.5 Gbps
Standard	db1v12m96	12 vCore	96 GB	Up to 12.5 Gbps
Standard	db1v12m144	12 vCore	144 GB	Up to 12.5 Gbps
Standard	db1v12m192	12 vCore	192 GB	Up to 12.5 Gbps
Standard	db1v14m28	14 vCore	28 GB	Up to 12.5 Gbps
Standard	db1v14m56	14 vCore	56 GB	Up to 12.5 Gbps
Standard	db1v14m112	14 vCore	112 GB	Up to 12.5 Gbps
Standard	db1v14m168	14 vCore	168 GB	Up to 12.5 Gbps
Standard	db1v14m224	14 vCore	224 GB	Up to 12.5 Gbps
Standard	db1v16m32	16 vCore	32 GB	Up to 12.5 Gbps
Standard	db1v16m64	16 vCore	64 GB	Up to 12.5 Gbps
Standard	db1v16m128	16 vCore	128 GB	Up to 12.5 Gbps
Standard	db1v16m192	16 vCore	192 GB	Up to 12.5 Gbps
Standard	db1v16m256	16 vCore	256 GB	Up to 12.5 Gbps

Table. Microsoft SQL Server (DBaaS) server type specifications - db1 server type

db2 server type

The db2 server type of Microsoft SQL Server (DBaaS) is offered with standard specifications (vCPU, Memory) and is suitable for various database workloads.

Intel 4th‑generation (Sapphire Rapids) Xeon Gold 6448H Processor up to 3.2 GHz
Supports up to 16 vCPUs and 256 GB of memory
Maximum networking speed of 12.5 Gbps

Category	Server type	vCPU	Memory	Network Bandwidth
Standard	db2v2m4	2 vCore	4 GB	Up to 10 Gbps
Standard	db2v8m8	2 vCore	8 GB	Up to 10 Gbps
Standard	db2v2m16	2 vCore	16 GB	Up to 10 Gbps
Standard	db2v2m24	2 vCore	24 GB	Up to 10 Gbps
Standard	db2v2m32	2 vCore	32 GB	Up to 10 Gbps
Standard	db2v4m8	4 vCore	8 GB	Up to 10 Gbps
Standard	db2v4m16	4 vCore	16 GB	Up to 10 Gbps
Standard	db2v4m32	4 vCore	32 GB	Up to 10 Gbps
Standard	db2v4m48	4 vCore	48 GB	Up to 10 Gbps
Standard	db2v4m64	4 vCore	64 GB	Up to 10 Gbps
Standard	db2v6m12	6 vCore	12 GB	Up to 10 Gbps
Standard	db2v6m24	6 vCore	24 GB	Up to 10 Gbps
Standard	db2v6m48	6 vCore	48 GB	Up to 10 Gbps
Standard	db2v72	6 vCore	72 GB	Up to 10 Gbps
Standard	db2v6m96	6 vCore	96 GB	Up to 10 Gbps
Standard	db2v8m16	8 vCore	16 GB	Up to 10 Gbps
Standard	db2v8m32	8 vCore	32 GB	Up to 10 Gbps
Standard	db2v8m64	8 vCore	64 GB	Up to 10 Gbps
Standard	db2v8m96	8 vCore	96 GB	Up to 10 Gbps
Standard	db2v8m128	8 vCore	128 GB	Up to 10 Gbps
Standard	db2v10m20	10 vCore	20 GB	Up to 10 Gbps
Standard	db2v10m40	10 vCore	40 GB	Up to 10 Gbps
Standard	db2v10m80	10 vCore	80 GB	Up to 10 Gbps
Standard	db2v10m120	10 vCore	120 GB	Up to 10 Gbps
Standard	db2v10m160	10 vCore	160 GB	Up to 10 Gbps
Standard	db2v12m24	12 vCore	24 GB	Up to 12.5 Gbps
Standard	db2v12m48	12 vCore	48 GB	Up to 12.5 Gbps
Standard	db2v12m96	12 vCore	96 GB	Up to 12.5 Gbps
Standard	db2v12m144	12 vCore	144 GB	Up to 12.5 Gbps
Standard	db2v12m192	12 vCore	192 GB	Up to 12.5 Gbps
Standard	db2v14m28	14 vCore	28 GB	Up to 12.5 Gbps
Standard	db2v14m56	14 vCore	56 GB	Up to 12.5 Gbps
Standard	db2v14m112	14 vCore	112 GB	Up to 12.5 Gbps
Standard	db2v14m168	14 vCore	168 GB	Up to 12.5 Gbps
Standard	db2v14m224	14 vCore	224 GB	Up to 12.5 Gbps
Standard	db2v16m32	16 vCore	32 GB	Up to 12.5 Gbps
Standard	db2v16m64	16 vCore	64 GB	Up to 12.5 Gbps
Standard	db2v16m128	16 vCore	128 GB	Up to 12.5 Gbps
Standard	db2v16m192	16 vCore	192 GB	Up to 12.5 Gbps
Standard	db2v16m256	16 vCore	256 GB	Up to 12.5 Gbps

Table. Microsoft SQL Server (DBaaS) server type specifications - db2 server type

dbh2 server type

The dbh2 server type of Microsoft SQL Server (DBaaS) is offered with high-capacity server specifications and is suitable for database workloads that require large-scale data processing.

Intel 4th‑generation (Sapphire Rapids) Xeon Gold 6448H Processor up to 3.2 GHz
Supports up to 128 vCPUs and 1,536 GB of memory
Networking speed up to 25 Gbps

Category	Server type	vCPU	Memory	Network Bandwidth
High Capacity	dbh2v24m48	24 vCore	48 GB	Maximum 25 Gbps
High Capacity	dbh2v24m96	24 vCore	96 GB	Maximum 25 Gbps
High Capacity	dbh2v24m192	24 vCore	192 GB	Maximum 25 Gbps
High Capacity	dbh2v24m288	24 vCore	288 GB	Maximum 25 Gbps
High Capacity	dbh2v32m64	32 vCore	64 GB	Up to 25 Gbps
High Capacity	dbh2v32m128	32 vCore	128 GB	Maximum 25 Gbps
High Capacity	dbh2v32m256	32 vCore	256 GB	Maximum 25 Gbps
High Capacity	dbh2v32m384	32 vCore	384 GB	Maximum 25 Gbps
High Capacity	dbh2v48m192	48 vCore	192 GB	Maximum 25 Gbps
High Capacity	dbh2v48m576	48 vCore	576 GB	Maximum 25 Gbps
High Capacity	dbh2v64m256	64 vCore	256 GB	Maximum 25 Gbps
High Capacity	dbh2v64m768	64 vCore	768 GB	Maximum 25 Gbps
High Capacity	dbh2v72m288	72 vCore	288 GB	Maximum 25 Gbps
High Capacity	dbh2v72m864	72 vCore	864 GB	Maximum 25 Gbps
High Capacity	dbh2v96m384	96 vCore	384 GB	Maximum 25 Gbps
High Capacity	dbh2v96m1152	96 vCore	1152 GB	Maximum 25 Gbps
High Capacity	dbh2v128m512	128 vCore	512 GB	Maximum 25 Gbps
High Capacity	dbh2v128m1536	128 vCore	1536 GB	Maximum 25 Gbps

Table. Microsoft SQL Server (DBaaS) server type specifications - dbh2 server type

2 - Monitoring metrics

Cloud Monitoring Service Termination Notice

According to the policy of Samsung Cloud Platform, the Cloud Monitoring service is scheduled to be discontinued.

Accordingly, services whose monitoring metrics are linked in Cloud Monitoring will no longer be able to monitor resources through Cloud Monitoring after the service improvement work in November 2026.
After that, resource monitoring can be continuously performed through the ServiceWatch service released in October 2025.

To ensure smooth service usage, proceed with the migration work according to the service termination schedule below.

Guide to Applying Monitoring Services by Resource
- New Resources: Resources created after the service improvement work in July 2026 are provided with monitoring using the ServiceWatch service by default.
- Existing resources: After the service improvement work in September 2026 We provide concurrent monitoring through Cloud Monitoring and ServiceWatch services.
- During the parallel operation period, we must prepare for the Servicewatch transition. *
  Performance and log data backup, the settings configured by users linked with existing Cloud Monitoring (e. You must verify items such as event policies and perform tasks such as resetting the ServiceWatch service, then complete them.
Notice of the phased termination schedule for the Cloud Monitoring service
- Console menu termination (September 2026 service improvement work)
  - You cannot access the Cloud Monitoring Console through the Console menu; you can only connect via the separate URLs for each region listed below.

Offering	Region	Cloud Monitoring console URL
Enterprise	kr-west1	https://console.kr-west1.e.samsungsdscloud.com/console/monitoring
Enterprise	kr-east1	https://console.kr-east1.e.samsungsdscloud.com/console/monitoring
Samsung	kr-west1	https://console.kr-west1.s.samsungsdscloud.com/console/monitoring
Samsung	kr-east1	https://console.kr-east1.s.samsungsdscloud.com/console/monitoring
Sovereign	kr-south1	https://console.kr-south1.g.samsungscloud.com/console/monitoring
Sovereign	kr-south2	https://console.kr-south2.g.samsungscloud.com/console/monitoring
Sovereign	kr-south3	https://console.kr-south3.g.samsungsdscloud.com/console/monitoring

Table. Cloud Monitoring console URLs by region

Service termination (service improvement work in November 2026)
- All services of Cloud Monitoring, including the API, will be permanently discontinued.
  - After the service ends in November, you will not be able to view Cloud Monitoring data. * Be sure to complete the ServiceWatch migration within the parallel operation period**.

Detailed information about ServiceWatch is available in the ServiceWatch Overview.

Microsoft SQL Server(DBaaS) Monitoring Metrics

The table below shows the performance monitoring metrics for Microsoft SQL Server (DBaaS) that can be viewed through Cloud Monitoring. For detailed usage of Cloud Monitoring, refer to the Cloud Monitoring guide.

Please refer to the Virtual Server Monitoring Metrics guide for Microsoft SQL Server(DBaaS) server monitoring metrics.

Performance items	Detailed description	unit
Active Locks	Number of Active Locks	cnt
Active Sessions	Number of Sessions in Active state	cnt
Active Transactions [Total]	Number of active transactions	cnt
Blocking Session ID	Long-running query (slow query)	ID
Connected Users	Number of users connected to the system	cnt
Datavolume Size [Free]	Available space	bytes
DBFiles [Not Online]	Run a query to verify that all data files are ONLINE.	cnt
Instance State [Cluster]	Status during MSSQL cluster configuration	state
Instance State [PID]	sqlservr.exe process pid	PID
Lock Processes [Blocked]	Number of SQL processes blocked by other processes	cnt
Lock Waits [Per Second]	Lock wait count per second	cnt
Page IO Latch Wait Time	Page IO latch waits average wait time	ms
Slowqueries	Number of SQL queries running for a long time (over 5 minutes)	cnt
Slowquery CPU Time	CPU time spent executing SQL that runs for a long time (over 5 minutes)	ms
Slowquery Execute Context ID	Context ID linked to the execution task of a SQL that has been running for a long time (over 5 minutes)	ID
Slowquery Memory Usage	Memory usage incurred by the execution of SQL that runs for a long time (over 5 minutes)	bytes
Slowquery Session ID	Session ID of SQL queries running for a long time (over 5 minutes)	ID
Slowquery Wait Duration Time	Total wait time for wait type	ms
Tablespace Used	Data volume size	bytes
Transaction Time [MAX]	Long-running transaction	cnt

Table. Microsoft SQL Server (DBaaS) Monitoring Metrics