MENU
      Cloud DB for MSSQL (VPC) metrics
        • PDF

        Cloud DB for MSSQL (VPC) metrics

        • PDF

        Article summary

        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 nameData typeUnitMetric typeDescriptionIntervalaggregation
          disk_queue_lengthLONGnumBasicLogicalDisk_AvgDiskQueueLengthMin1,Min5,Min30,Hour2,Day1
          disk_ms_per_readLONGnumBasic, DefaultLogicalDisk_AvgDiskMsPerReadMin1,Min5,Min30,Hour2,Day1
          disk_ms_per_writeLONGnumBasic, DefaultLogicalDisk_AvgDiskMsPerWriteMin1,Min5,Min30,Hour2,Day1
          disk_readLONGbytes/secBasicLogicalDisk_DiskReadBytesPerSecMin1,Min5,Min30,Hour2,Day1
          disk_writeLONGbytes/secBasicLogicalDisk_DiskWriteBytesPerSecMin1,Min5,Min30,Hour2,Day1
          disk_freeLONGMBBasicLogicalDisk_FreeMegabytesMin1,Min5,Min30,Hour2,Day1
          memory_availableLONGMBBasic, DefaultMemory_AvailablembytesMin1,Min5,Min30,Hour2,Day1
          nic_receiveLONGbytes/secBasicNetworkInterface_BytesReceivedPerSecMin1,Min5,Min30,Hour2,Day1
          nic_sentLONGbytes/secBasicNetworkInterface_BytesSentPerSecMin1,Min5,Min30,Hour2,Day1
          nic_packetLONGpackets/secBasicNetworkInterface_PacketsPerSecMin1,Min5,Min30,Hour2,Day1
          nic_tcp_rscLONGpackets/secBasicNetworkInterface_TCPRSCCoalescedPacketsPerSecMin1,Min5,Min30,Hour2,Day1
          cpuLONG%Basic, DefaultProcessor_PercetProcessorTimeMin1,Min5,Min30,Hour2,Day1
          cpu_context_switchLONGnum/secBasicSystem_ContextSwitchesPerSecMin1,Min5,Min30,Hour2,Day1
          cpu_queue_lengthLONGnumBasicSystem_ProcessorQueueLengthMin1,Min5,Min30,Hour2,Day1
          mssql_lazywriteLONGwrites/secBasicSQLServerBufferManager_LazywritesPerSecMin1,Min5,Min30,Hour2,Day1
          mssql_page_life_expectancyLONGnumBasicSQLServerBufferManager_PagelifeexpectancyMin1,Min5,Min30,Hour2,Day1
          mssql_page_lookupLONGnum/secBasic, DefaultSQLServerBufferManager_PagelookupsPerSecMin1,Min5,Min30,Hour2,Day1
          mssql_page_readLONGnum/secBasic, DefaultSQLServerBufferManager_PagereadsPerSecMin1,Min5,Min30,Hour2,Day1
          mssql_page_writeLONGnum/secBasicSQLServerBufferManager_PagewritesPerSecMin1,Min5,Min30,Hour2,Day1
          mssql_user_connectionLONGnumBasic, DefaultSQLServerGeneralStatistics_UserConnectionsMin1,Min5,Min30,Hour2,Day1
          mssql_latch_wait_time_msLONGnumBasicSQLServerLatches_TotalLatchWaitTimeMsMin1,Min5,Min30,Hour2,Day1
          mssql_lock_wait_time_msLONGnumBasic, DefaultSQLServerLocks_LockWaitTimeMsMin1,Min5,Min30,Hour2,Day1
          mssql_free_memoryLONGKBBasicSQLServerMemoryManager_FreeMemoryKBMin1,Min5,Min30,Hour2,Day1
          mssql_mem_grant_pendingLONGnum/secBasicSQLServerMemoryManager_MemoryGrantsPendingMin1,Min5,Min30,Hour2,Day1
          mssql_batchrequestLONGnum/secBasic, DefaultSQLServerSQLStatistics_BatchRequestsPerSecMin1,Min5,Min30,Hour2,Day1
          mssql_compilationLONGnum/secBasic, DefaultSQLServerSQLStatistics_SQLCompilationsPerSecMin1,Min5,Min30,Hour2,Day1
          mssql_recompilationLONGnum/secBasicSQLServerSQLStatistics_SQLReCompilationsPerSecMin1,Min5,Min30,Hour2,Day1
          disk_free_percentLONG%BasicLogicalDisk_PercetFreeSpaceMin1,Min5,Min30,Hour2,Day1
        • Dimension
          Dimension nameData type
          instanceNo

        query metric

        query metric-related performance/operational metrics are as follows.

        • Metric
          Metric nameData typeUnitMetric typeDescriptionIntervalAggregation
          d_total_worker_timeLONGusBasicdm_exec_query_stats_delta_worker_timeMin1,Min5,Min30,Hour2,Day1
          d_total_logical_readsLONGpageBasicdm_exec_query_stats_delta_logical_readsMin1,Min5,Min30,Hour2,Day1
          d_total_physical_readsLONGpageBasicdm_exec_query_stats_delta_physical_readsMin1,Min5,Min30,Hour2,Day1
          d_total_logical_writesLONGpageBasicdm_exec_query_stats_delta_logical_writesMin1,Min5,Min30,Hour2,Day1
          d_total_elapsed_timeLONGusBasicdm_exec_query_stats_delta_elapsed_timeMin1,Min5,Min30,Hour2,Day1
          d_total_grant_kbLONGKBBasicdm_exec_query_stats_delta_grant_kbMin1,Min5,Min30,Hour2,Day1
          d_execution_countLONGnumBasicdm_exec_query_stats_delta_execution_countMin1,Min5,Min30,Hour2,Day1
        • Dimension
          Dimension nameData type
          instanceNo
          query_hash

        Was this article helpful?

        Changing your password will log you out immediately. Use the new password to log back in.
        First name must have atleast 2 characters. Numbers and special characters are not allowed.
        Last name must have atleast 1 characters. Numbers and special characters are not allowed.
        Enter a valid email
        Enter a valid password
        Your profile has been successfully updated.