--- title: "Cloud DB for MSSQL (VPC) metrics" slug: "database-vmssql-metric" updated: 2026-09-17T10:05:51Z published: 2026-09-17T10:05:51Z canonical: "api.ncloud-docs.com/database-vmssql-metric" --- > ## Documentation Index > Fetch the complete documentation index at: https://api.ncloud-docs.com/llms.txt > Use this file to discover all available pages before exploring further. # Cloud DB for MSSQL (VPC) metrics Available in VPC This section provides information on the performance and operational metrics of the Cloud DB for MSSQL service. Performance/operational metrics can be managed in an integrated manner through NAVER Cloud Platform's Cloud Insight service and can be used for various monitoring purposes. Note See the [Cloud Insight API Guide](/docs/en/management-cloudinsight) for information on how to use performance/operational metrics for monitoring. ## Basic information The following is the basic information of the Cloud DB for MSSQL service for using performance/operational metrics. - Product name (`prodName`) - System/Cloud DB for MSSQL(VPC) - Product key (`cw_key`) - 548847168836997120 - Metric type - [normal metric](/docs/en/database-vmssql-metric#normalmetric) - [query metric](/docs/en/database-vmssql-metric#querymetric) ## Performance/operation metrics The performance/operational metrics of the Cloud DB for MSSQL service are as follows. ### normal metric normal metric-related performance/operational metrics are as follows. - Metric | Metric name | Data type | Unit | Metric type | Description | Interval | aggregation | | --- | --- | --- | --- | --- | --- | --- | | | disk_queue_length | LONG | num | Basic | LogicalDisk_AvgDiskQueueLength | Min1,Min5,Min30,Hour2,Day1 | | | disk_ms_per_read | LONG | num | Basic, Default | LogicalDisk_AvgDiskMsPerRead | Min1,Min5,Min30,Hour2,Day1 | | | disk_ms_per_write | LONG | num | Basic, Default | LogicalDisk_AvgDiskMsPerWrite | Min1,Min5,Min30,Hour2,Day1 | | | disk_read | LONG | bytes/sec | Basic | LogicalDisk_DiskReadBytesPerSec | Min1,Min5,Min30,Hour2,Day1 | | | disk_write | LONG | bytes/sec | Basic | LogicalDisk_DiskWriteBytesPerSec | Min1,Min5,Min30,Hour2,Day1 | | | disk_free | LONG | MB | Basic | LogicalDisk_FreeMegabytes | Min1,Min5,Min30,Hour2,Day1 | | | memory_available | LONG | MB | Basic, Default | Memory_Availablembytes | Min1,Min5,Min30,Hour2,Day1 | | | nic_receive | LONG | bytes/sec | Basic | NetworkInterface_BytesReceivedPerSec | Min1,Min5,Min30,Hour2,Day1 | | | nic_sent | LONG | bytes/sec | Basic | NetworkInterface_BytesSentPerSec | Min1,Min5,Min30,Hour2,Day1 | | | nic_packet | LONG | packets/sec | Basic | NetworkInterface_PacketsPerSec | Min1,Min5,Min30,Hour2,Day1 | | | nic_tcp_rsc | LONG | packets/sec | Basic | NetworkInterface_TCPRSCCoalescedPacketsPerSec | Min1,Min5,Min30,Hour2,Day1 | | | cpu | LONG | % | Basic, Default | Processor_PercetProcessorTime | Min1,Min5,Min30,Hour2,Day1 | | | cpu_context_switch | LONG | num/sec | Basic | System_ContextSwitchesPerSec | Min1,Min5,Min30,Hour2,Day1 | | | cpu_queue_length | LONG | num | Basic | System_ProcessorQueueLength | Min1,Min5,Min30,Hour2,Day1 | | | mssql_lazywrite | LONG | writes/sec | Basic | SQLServerBufferManager_LazywritesPerSec | Min1,Min5,Min30,Hour2,Day1 | | | mssql_page_life_expectancy | LONG | num | Basic | SQLServerBufferManager_Pagelifeexpectancy | Min1,Min5,Min30,Hour2,Day1 | | | mssql_page_lookup | LONG | num/sec | Basic, Default | SQLServerBufferManager_PagelookupsPerSec | Min1,Min5,Min30,Hour2,Day1 | | | mssql_page_read | LONG | num/sec | Basic, Default | SQLServerBufferManager_PagereadsPerSec | Min1,Min5,Min30,Hour2,Day1 | | | mssql_page_write | LONG | num/sec | Basic | SQLServerBufferManager_PagewritesPerSec | Min1,Min5,Min30,Hour2,Day1 | | | mssql_user_connection | LONG | num | Basic, Default | SQLServerGeneralStatistics_UserConnections | Min1,Min5,Min30,Hour2,Day1 | | | mssql_latch_wait_time_ms | LONG | num | Basic | SQLServerLatches_TotalLatchWaitTimeMs | Min1,Min5,Min30,Hour2,Day1 | | | mssql_lock_wait_time_ms | LONG | num | Basic, Default | SQLServerLocks_LockWaitTimeMs | Min1,Min5,Min30,Hour2,Day1 | | | mssql_free_memory | LONG | KB | Basic | SQLServerMemoryManager_FreeMemoryKB | Min1,Min5,Min30,Hour2,Day1 | | | mssql_mem_grant_pending | LONG | num/sec | Basic | SQLServerMemoryManager_MemoryGrantsPending | Min1,Min5,Min30,Hour2,Day1 | | | mssql_batchrequest | LONG | num/sec | Basic, Default | SQLServerSQLStatistics_BatchRequestsPerSec | Min1,Min5,Min30,Hour2,Day1 | | | mssql_compilation | LONG | num/sec | Basic, Default | SQLServerSQLStatistics_SQLCompilationsPerSec | Min1,Min5,Min30,Hour2,Day1 | | | mssql_recompilation | LONG | num/sec | Basic | SQLServerSQLStatistics_SQLReCompilationsPerSec | Min1,Min5,Min30,Hour2,Day1 | | | disk_free_percent | LONG | % | Basic | LogicalDisk_PercetFreeSpace | Min1,Min5,Min30,Hour2,Day1 | - Dimension | Dimension name | Data type | | --- | --- | | | instanceNo | ### query metric query metric-related performance/operational metrics are as follows. - Metric | Metric name | Data type | Unit | Metric type | Description | Interval | Aggregation | | --- | --- | --- | --- | --- | --- | --- | | | d_total_worker_time | LONG | us | Basic | dm_exec_query_stats_delta_worker_time | Min1,Min5,Min30,Hour2,Day1 | | | d_total_logical_reads | LONG | page | Basic | dm_exec_query_stats_delta_logical_reads | Min1,Min5,Min30,Hour2,Day1 | | | d_total_physical_reads | LONG | page | Basic | dm_exec_query_stats_delta_physical_reads | Min1,Min5,Min30,Hour2,Day1 | | | d_total_logical_writes | LONG | page | Basic | dm_exec_query_stats_delta_logical_writes | Min1,Min5,Min30,Hour2,Day1 | | | d_total_elapsed_time | LONG | us | Basic | dm_exec_query_stats_delta_elapsed_time | Min1,Min5,Min30,Hour2,Day1 | | | d_total_grant_kb | LONG | KB | Basic | dm_exec_query_stats_delta_grant_kb | Min1,Min5,Min30,Hour2,Day1 | | | d_execution_count | LONG | num | Basic | dm_exec_query_stats_delta_execution_count | Min1,Min5,Min30,Hour2,Day1 | - Dimension | Dimension name | Data type | | --- | --- | | | instanceNo | | | query_hash |