Cloud DB for MSSQL (VPC) 지표

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

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

기본 정보

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

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

성능/운영 지표

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