The page has been translated by Gen AI.

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

Monitoring metrics

How-to guides