Cloud DB for MSSQL (VPC) 지표

Prev Next

VPC 환경에서 이용 가능합니다.

Cloud DB for MSSQL 서비스의 성능/운영 지표(메트릭) 관련 정보를 안내합니다. 성능/운영 지표는 네이버 클라우드 플랫폼의 Cloud Insight 서비스를 통해 통합 관리할 수 있으며, 다양한 모니터링에 활용이 가능합니다.

참고

성능/운영 지표를 모니터링에 활용하는 방법은 Cloud Insight API 가이드를 참조해 주십시오.

기본 정보

성능/운영 지표를 활용하기 위한 Cloud DB for MSSQL 서비스의 기본 정보는 다음과 같습니다.

  • 상품 이름(prodName)
    • System/Cloud DB for MSSQL(VPC)
  • 상품 키(cw_key)
    • 734407999690510336
  • 메트릭 유형

성능/운영 지표

Cloud DB for MSSQL 서비스의 성능/운영 지표는 다음과 같습니다.

normal metric

normal metric 관련 성능/운영 지표는 다음과 같습니다.

  • Metric
    Metric name Data type Unit Metric type Description Interval aggregation
    disk_queue_length LONG num Basic LogicalDisk_AvgDiskQueueLength Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_ms_per_read LONG num Basic, Default LogicalDisk_AvgDiskMsPerRead Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_ms_per_write LONG num Basic, Default LogicalDisk_AvgDiskMsPerWrite Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_read LONG bytes/sec Basic LogicalDisk_DiskReadBytesPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_write LONG bytes/sec Basic LogicalDisk_DiskWriteBytesPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_free LONG MB Basic LogicalDisk_FreeMegabytes Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    memory_available LONG MB Basic, Default Memory_Availablembytes Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    nic_receive LONG bytes/sec Basic NetworkInterface_BytesReceivedPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    nic_sent LONG bytes/sec Basic NetworkInterface_BytesSentPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    nic_packet LONG packets/sec Basic NetworkInterface_PacketsPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    nic_tcp_rsc LONG packets/sec Basic NetworkInterface_TCPRSCCoalescedPacketsPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu LONG % Basic, Default Processor_PercetProcessorTime Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu_context_switch LONG num/sec Basic System_ContextSwitchesPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    cpu_queue_length LONG num Basic System_ProcessorQueueLength Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_lazywrite LONG writes/sec Basic SQLServerBufferManager_LazywritesPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_page_life_expectancy LONG num Basic SQLServerBufferManager_Pagelifeexpectancy Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_page_lookup LONG num/sec Basic, Default SQLServerBufferManager_PagelookupsPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_page_read LONG num/sec Basic, Default SQLServerBufferManager_PagereadsPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_page_write LONG num/sec Basic SQLServerBufferManager_PagewritesPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_user_connection LONG num Basic, Default SQLServerGeneralStatistics_UserConnections Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_latch_wait_time_ms LONG num Basic SQLServerLatches_TotalLatchWaitTimeMs Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_lock_wait_time_ms LONG num Basic, Default SQLServerLocks_LockWaitTimeMs Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_free_memory LONG KB Basic SQLServerMemoryManager_FreeMemoryKB Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_mem_grant_pending LONG num/sec Basic SQLServerMemoryManager_MemoryGrantsPending Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_batchrequest LONG num/sec Basic, Default SQLServerSQLStatistics_BatchRequestsPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_compilation LONG num/sec Basic, Default SQLServerSQLStatistics_SQLCompilationsPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    mssql_recompilation LONG num/sec Basic SQLServerSQLStatistics_SQLReCompilationsPerSec Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    disk_free_percent LONG % Basic LogicalDisk_PercetFreeSpace Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
  • Dimension
    Dimension name Data type
    instanceNo STRING

query metric

query metric 관련 성능/운영 지표는 다음과 같습니다.

  • 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 AVG,MAX,MIN,SUM,COUNT
    d_total_logical_reads LONG page Basic dm_exec_query_stats_delta_logical_reads Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    d_total_physical_reads LONG page Basic dm_exec_query_stats_delta_physical_reads Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    d_total_logical_writes LONG page Basic dm_exec_query_stats_delta_logical_writes Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    d_total_elapsed_time LONG us Basic dm_exec_query_stats_delta_elapsed_time Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    d_total_grant_kb LONG KB Basic dm_exec_query_stats_delta_grant_kb Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
    d_execution_count LONG num Basic dm_exec_query_stats_delta_execution_count Min1,Min5,Min30,Hour2,Day1 AVG,MAX,MIN,SUM,COUNT
  • Dimension
    Dimension name Data type
    instanceNo STRING
    query_hash STRING