VPC環境で利用できます。
Cloud DB for MSSQLサービスのパフォーマンス/運用指標(メトリック)関連情報の説明です。パフォーマンス/運用指標は、NAVERクラウドプラットフォームの Cloud Insightサービスを通じて統合管理することができ、さまざまなモニタリングに活用できます。
参考
パフォーマンス/運用指標をモニタリングに活用する方法は、Cloud Insight APIガイドをご参照ください。
基本情報
パフォーマンス/運用指標を活用するための Cloud DB for MSSQLサービスの基本情報は次の通りです。
- 商品名(
prodName)- System/Cloud DB for MSSQL(VPC)
- 商品キー(
cw_key)- 548847168836997120
- メトリックのタイプ
パフォーマンス/運用指標
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 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関連のパフォーマンス/運用指標は次の通りです。
- 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