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 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
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