MENU
      Cloud DB for MSSQL (VPC) 지표

        Cloud DB for MSSQL (VPC) 지표


        기사 요약

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

        Cloud DB for MSSQL 서비스의 성능/운영 지표(메트릭) 관련 정보를 안내합니다. 성능/운영 지표는 네이버 클라우드 플랫폼의 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 nameData typeUnitMetric typeDescriptionIntervalaggregation
          disk_queue_lengthLONGnumBasicLogicalDisk_AvgDiskQueueLengthMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          disk_ms_per_readLONGnumBasic, DefaultLogicalDisk_AvgDiskMsPerReadMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          disk_ms_per_writeLONGnumBasic, DefaultLogicalDisk_AvgDiskMsPerWriteMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          disk_readLONGbytes/secBasicLogicalDisk_DiskReadBytesPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          disk_writeLONGbytes/secBasicLogicalDisk_DiskWriteBytesPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          disk_freeLONGMBBasicLogicalDisk_FreeMegabytesMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          memory_availableLONGMBBasic, DefaultMemory_AvailablembytesMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          nic_receiveLONGbytes/secBasicNetworkInterface_BytesReceivedPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          nic_sentLONGbytes/secBasicNetworkInterface_BytesSentPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          nic_packetLONGpackets/secBasicNetworkInterface_PacketsPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          nic_tcp_rscLONGpackets/secBasicNetworkInterface_TCPRSCCoalescedPacketsPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          cpuLONG%Basic, DefaultProcessor_PercetProcessorTimeMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          cpu_context_switchLONGnum/secBasicSystem_ContextSwitchesPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          cpu_queue_lengthLONGnumBasicSystem_ProcessorQueueLengthMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_lazywriteLONGwrites/secBasicSQLServerBufferManager_LazywritesPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_page_life_expectancyLONGnumBasicSQLServerBufferManager_PagelifeexpectancyMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_page_lookupLONGnum/secBasic, DefaultSQLServerBufferManager_PagelookupsPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_page_readLONGnum/secBasic, DefaultSQLServerBufferManager_PagereadsPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_page_writeLONGnum/secBasicSQLServerBufferManager_PagewritesPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_user_connectionLONGnumBasic, DefaultSQLServerGeneralStatistics_UserConnectionsMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_latch_wait_time_msLONGnumBasicSQLServerLatches_TotalLatchWaitTimeMsMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_lock_wait_time_msLONGnumBasic, DefaultSQLServerLocks_LockWaitTimeMsMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_free_memoryLONGKBBasicSQLServerMemoryManager_FreeMemoryKBMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_mem_grant_pendingLONGnum/secBasicSQLServerMemoryManager_MemoryGrantsPendingMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_batchrequestLONGnum/secBasic, DefaultSQLServerSQLStatistics_BatchRequestsPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_compilationLONGnum/secBasic, DefaultSQLServerSQLStatistics_SQLCompilationsPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          mssql_recompilationLONGnum/secBasicSQLServerSQLStatistics_SQLReCompilationsPerSecMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          disk_free_percentLONG%BasicLogicalDisk_PercetFreeSpaceMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
        • Dimension
          Dimension nameData type
          instanceNoSTRING

        query metric

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

        • Metric
          Metric nameData typeUnitMetric typeDescriptionIntervalAggregation
          d_total_worker_timeLONGusBasicdm_exec_query_stats_delta_worker_timeMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          d_total_logical_readsLONGpageBasicdm_exec_query_stats_delta_logical_readsMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          d_total_physical_readsLONGpageBasicdm_exec_query_stats_delta_physical_readsMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          d_total_logical_writesLONGpageBasicdm_exec_query_stats_delta_logical_writesMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          d_total_elapsed_timeLONGusBasicdm_exec_query_stats_delta_elapsed_timeMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          d_total_grant_kbLONGKBBasicdm_exec_query_stats_delta_grant_kbMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
          d_execution_countLONGnumBasicdm_exec_query_stats_delta_execution_countMin1,Min5,Min30,Hour2,Day1AVG,MAX,MIN,SUM,COUNT
        • Dimension
          Dimension nameData type
          instanceNoSTRING
          query_hashSTRING

        이 문서가 도움이 되었습니까?

        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.