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 type
2: Monitoring metrics
3: ServiceWatch metric

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 can automate Microsoft SQL Server installation and perform 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 the desired point in time.

Provided features

Microsoft SQL Server (DBaaS) provides the following features.

Auto Provisioning (Auto Provisioning): UI allows installation and configuration of Database (DB), and provides a Primary-Secondary redundancy configuration built on Always On. * When the Primary server fails, it automatically fails over to the Secondary.
Operation Control Management: Provides a function to control the status of running servers. * In addition to start and stop, a restart is possible if there is a DB issue or to apply configuration changes. * When high availability (HA) is configured, the node transition between Primary and Secondary can be performed directly by the user through a switch-over.
Backup and Recovery: Provides data backup functionality based on its own backup commands. * Backup time slots and storage locations, as well as the day of full backups, can be set by the user, and additional fees may apply based on backup size. * It also provides a recovery feature for backed‑up data, so when a user initiates a recovery, a separate database is created and the recovery proceeds to the point in time selected by the user (the backup creation time or a user‑specified time). * When restoring to a user-specified point in time, you can set the restore point up to 5 minutes, 10 minutes, 30 minutes, or 1 hour before the stored backup and archive files.
Version Management: Provides a Minor version upgrade feature based on some functionality improvements and security patches.
Secondary configuration: It is possible to add a Read Replica (Secondary Replica) for read load balancing and disaster recovery (DR).
Audit setting: Provides an Audit setting feature that can monitor users’ DB access and the results of DDL (Data Definition Language)/DML (Data Manipulation Language) operations.
Parameter management: You can modify DB configuration parameters related to performance improvement and security.
Service Status Query: Retrieves the final status of the current DB service.
Monitoring: CPU, memory, performance monitoring information can be viewed through Cloud Monitoring and Servicewatch.
DB User Management: View and manage the DB account (user) information registered in the DB.
DB Log Export: You can export stored logs to the user’s Object Storage through Audit settings.

Components

Microsoft SQL Server(DBaaS) provides pre-validated engine versions and a variety of server types. Users can choose and use it based on 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 is available 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.

Since the EOS and EoTS dates may change according to the supplier’s policy, 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

service	Provided version	Minor patch number / version	EoS Date (Samsung Cloud Plaform New Creation Stop Date)	EoTS date (Community technical support end date)
MS SQL Server	2019 (Standard, Enterprise)	KB5033688 / 15.0.4355.3	2029-06 (planned)	Extended support: 2030-01-08 Mainstream support: 2025-02-28
	2019 (Standard, Enterprise)	KB5046365 / 15.0.4405.4	2029-06 (planned)	Extended support: 2030-01-08 Mainstream support: 2025-02-28
	2019 (Standard, Enterprise)	KB5054833 / 15.0.4430.1	2029-06 (scheduled)	Extended support: 2030-01-08 Mainstream support: 2025-02-28
	2019 (Standard, Enterprise)	KB5058722 / 15.0.4435.7	2029-06 (planned)	Extended support: 2030-01-08 Mainstream support: 2025-02-28
	2022 (Standard, Enterprise)	KB5048033 / 16.0.4165.4	2032-06 (planned)	Extended support: 2033-01-11 Mainstream support: 2028-01-11
	2022 (Standard, Enterprise)	KB5050771 / 16.0.4185.3	2032-06 (planned)	Extended support: 2033-01-11 Mainstream support: 2028-01-11
	2022 (Standard, Enterprise)	KB5058721 / 16.0.4200.1	2032-06 (planned)	Extended support: 2033-01-11 Mainstream support: 2028-01-11
	2022 (Standard, Enterprise)	KB5059390 / 16.0.4205.1	2032-06 (planned)	Extended support: 2033-01-11 Mainstream support: 2028-01-11
	2022 (Standard, Enterprise)	KB5065865 / 16.0.4215.2	2032-06 (planned)	Extended support: 2033-01-11 Mainstream support: 2028-01-11

Table. Microsoft SQL Server (DBaaS) engine version provided

Information

The next version of MS SQL Server is scheduled to be available after September 2026. The actual service delivery schedule is subject to change.

MS SQL Server 2022 (Standard, Enterprise) KB5078297 / 16.0.4236.2

Server type

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

Please refer to Microsoft SQL Server(DBaaS) 서버 타입 for detailed information about the server types provided by Microsoft SQL Server (DBaaS).

Standard db1v2m4

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

Table. Microsoft SQL Server (DBaaS) server type components

Preceding Service

This is a list of services that must be pre‑configured before creating the service. For detailed information, 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) pre-service

1 - Server type

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.

Reference

The server types offered may vary depending on the region and AZ.

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

Standard db1v2m4

Category	Example	Detailed description
Server type	Standard	Provided server type categories Standard: Configured with standard specifications (vCPU, Memory) commonly used High Capacity: Large-capacity server specifications exceeding Standard
Server specifications	db1	Provided server type classification and generation db1: indicates a standard specification, and 1 denotes the generation dbh2: h indicates a high-capacity server specification, and 2 denotes 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 offered 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	Maximum 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	Maximum 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	Up to 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

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

3 - ServiceWatch metric

Microsoft SQL Server(DBaaS) sends metrics to ServiceWatch. The metrics provided by basic monitoring are data collected at 1‑minute intervals.

Reference

For how to view metrics in ServiceWatch, refer to the ServiceWatch guide.

basic metrics

The following are basic metrics for the Microsoft SQL Server(DBaaS) namespace.

In the table below, the metrics whose names are shown in bold are the key metrics selected from those provided by Microsoft SQL Server (DBaaS). The main metrics are used to configure the service dashboards that are automatically built for each service in ServiceWatch.

Each metric provides guidance in the user guide on which statistical values are meaningful when viewing that metric, and among the meaningful statistics, the values displayed in bold are the primary statistics. In the service dashboard, you can view key metrics through primary statistical values.

OS Basic Metrics

Classification	Performance items	unit	Detailed description	meaningful statistics
CPU	CPU Usage	Percent	CPU usage	Total Average Maximum Minimum
Disk	Disk Usage	Percent	Disk usage	Total Average Maximum Minimum
Disk	Disk Write Bytes	Bytes/Second	Write capacity (bytes/second) on block device	Total Average Maximum Minimum
Disk	Disk Read Bytes	Bytes/Second	Read throughput from block device (bytes/second)	Total Average Maximum Minimum
Disk	Disk Write Requests	Count/Second	Number of write requests on block device (requests per second)	Total Average Maximum Minimum
Disk	Disk Read Requests	Count/Second	Number of read requests on block device (requests per second)	Total Average Maximum Minimum
Disk	Average Disk I/O Queue Size	None	Average queue length of requests issued to the block device	Total Average Maximum Minimum
Disk	Disk I/O Utilization	Percent	The proportion of time the block device actually spent processing I/O operations	Total Average Maximum Minimum
Memory	Memory Usage	Percent	Memory usage	Total Average Maximum Minimum
Memory	Swap Out Bytes	Bytes/Second	Data transferred from memory to swap area (bytes/second)	Total Average Maximum Minimum
Memory	Swap Used Bytes	Bytes	Current swap space size	Total Average Maximum Minimum
Memory	Swap Cached Usage	Percent	Cached swap usage rate	Total Average Maximum Minimum
Memory	Swap Total Bytes	Bytes	Total swap space size configured on the system	Total Average Maximum Minimum
Memory	Swap In Bytes	Bytes/Second	Amount read from swap area to memory (bytes/second)	Total Average Maximum Minimum
Memory	Swap Usage	Percent	Current usage ratio relative to total swap space	Total Average Maximum Minimum
Memory	Swap Cached Bytes	Bytes	Size of pages that have been restored to memory but still have a copy in the swap area	Total Average Maximum Minimum
Memory	Swap Free Bytes	Bytes	Size of unused remaining swap space	Total Average Maximum Minimum
Network	Network In Bytes	Bytes/Second	Received capacity (bytes/second) on the network interface	Total Average Maximum Minimum
Network	Network Out Bytes	Bytes/Second	Transmitted capacity (bytes/second) on the network interface	Total Average Maximum Minimum
Network	TCP Connections	Count/Second	Total number of TCP connections currently established correctly	Total Average Maximum Minimum
Network	Network In Packets	Count	Number of packets received on the network interface	Total Average Maximum Minimum
Network	Network Out Packets	Count	Number of packets transmitted on the network interface	Total Average Maximum Minimum
Network	Network In Dropped	Count	Number of packet drops received on the network interface	Total Average Maximum Minimum
Network	Network Out Dropped	Count	Number of packet drops transmitted from the network interface	Total Average Maximum Minimum
Network	Network In Errors	Count	Number of packet errors received on the network interface	Total Average Maximum Minimum
Network	Network Out Errors	Count	Number of packet errors transmitted on the network interface	Total Average Maximum Minimum
OS	OS Uptime	Seconds	Time elapsed (seconds) since the system was last booted	Total Average Maximum Minimum

Table. OS basic metrics

Microsoft SQL Server(DBaaS) Basic Metrics

Classification	Performance items	unit	Detailed description	meaningful statistics
General	Page Life Expectancy Seconds	Seconds	Estimated time (seconds) that a data page remains in the buffer pool without disk re-reference	Total Average Maximum Minimum
General	Full Scans/sec	Count/Second	Number of Table Full Scans per second	Total Average Maximum Minimum
General	Range Scans/sec	Count/Second	Number of Range Scans performed per second	Total Average Maximum Minimum
General	Index Searches/sec	Count/Second	Number of Index Searches performed per second	Total Average Maximum Minimum
General	Buffer Cache Hit ratio	Percent	Proportion of page requests processed directly from the buffer cache	Total Average Maximum Minimum
General	Cursor Requests/Sec	Count/Second	Number of SQL cursor requests received by the server per second	Total Average Maximum Minimum
General	Page Fault Count	Count	Number of page faults for all processes, including system processes	Total Average Maximum Minimum
Locks & Latches	Lock Requests/Sec	Count/Second	Number of lock requests per second	Total Average Maximum Minimum
Locks & Latches	Lock Blocks	Count	Number of blocks where a lock occurred	Total Average Maximum Minimum
Locks & Latches	Table Lock Escalation/Sec	Count/Second	The number of locked blocks per second became excessive, causing escalation to table-wide locking.	Total Average Maximum Minimum
Locks & Latches

| Count/Second | Dead Lock count per second |

Total

Average

Maximum

Minimum

Total

Average

Maximum

Minimum

Total

Average

Maximum

Minimum

Total

Average

Maximum

Minimum

Total

Average

Maximum

Minimum

Total

Average

Maximum

Minimum

up: 1

down: 0

Total

Average

Maximum

Minimum

Total

Average

Maximum

Minimum

Total

Average

Maximum

Minimum

Total

Average

Maximum

Minimum

Table. Microsoft SQL Server (DBaaS) basic metrics