SQL Server Monitoring
가져오는 방법
Datadog에서 Dashboards → New Dashboard → ⚙ Configure → Import dashboard JSON 순으로 이동한 뒤 이 JSON을 붙여넣으세요.
반응
Performance and health metrics for your SQL Servers using Telegraf and Prometheus

변환 품질
보통 72쿼리가 손실 없이 변환된 패널의 비율입니다. 일부만 변환됐거나 지원되지 않는 패널은 원본 PromQL을 노트 위젯에 그대로 남겨 둡니다.
- 기본 통합0
- OpenMetrics48
- 일부 변환1
- 미지원18
Datadog 기본 통합 메트릭으로 매핑되지 않은 항목
OpenMetrics 이름을 그대로 사용한 메트릭입니다. Datadog 기본 통합으로 수집 중이라면 메트릭 이름을 맞춰 주세요.
State_OFFLINE_total ×2CPU_____SQL_process ×2CPU_____External_process ×2User_Connections___General_Statistics ×2Log_Flushes_sec____Total___Databases ×2State_ONLINE_totalState_SUSPECT_totalState_RECOVERING_totalState_RECOVERY_PENDING_totalState_RESTORING_totalPerformance_metrics_Point_In_Time_RecoveryRecovery_Model_FULL_totalRecovery_Model_BULK_LOGGED_totalRecovery_Model_SIMPLE_totalCPU_____SystemIdlePerformance_metrics_Signal_wait____Performance_metrics_Average_tasksPerformance_metrics_Average_runnable_tasksTarget_Server_Memory__KB____Memory_ManagerTotal_Server_Memory__KB____Memory_ManagerPerformance_metrics_Total_target_memory_ratioPerformance_metrics_Page_File_Usage____Page_life_expectancy___Buffer_ManagerPerformance_metrics_Buffer_pool_rate__bytes_sec_Free_list_stalls_sec___Buffer_ManagerMemory_Grants_Pending___Memory_ManagerRows_reads__bytes_sec__TotalLog_reads__bytes_sec__TotalRows_writes__bytes_sec__TotalLog_writes__bytes_sec__TotalPerformance_metrics_Average_pending_disk_IONetwork_IO_waits___Average_wait_time__ms____Wait_StatisticsPerformance_metrics_Connection_memory_per_connection__bytes_Data_File_s__Size__KB_____Total___DatabasesData_File_s__Size__KB____mssqlsystemresource___DatabasesPercent_Log_Used____Total___DatabasesPercent_Log_Used___mssqlsystemresource___DatabasesBackup_Restore_Throughput_sec____Total___DatabasesBatch_Requests_sec___SQL_StatisticsLogins_sec___General_StatisticsLogouts_sec___General_StatisticsSQL_Compilations_sec___SQL_StatisticsSQL_Re_Compilations_sec___SQL_StatisticsProcesses_blocked___General_StatisticsTransactions_sec____Total___DatabasesWrite_Transactions_sec____Total___DatabasesLog_Flush_Wait_Time____Total___DatabasesLock_Timeouts_sec____Total___LocksNumber_of_Deadlocks_sec____Total___LocksLock_Waits_sec____Total___Locks지원되지 않는 패널
- Wait Time
graph - Wait Tasks
graph - Memory (%)
graph - Memory (bytes)
graph - Database | Rows Size
graph - Database | Log Size
graph - Reads | Rows Bytes
graph - Reads | Log Bytes
graph - Writes | Rows Bytes
graph - Writes | Log Bytes
graph - Reads | Rows (ms)
graph - Reads | Log (ms)
graph - Writes | Rows (ms)
graph - Writes | Log (ms)
graph - Used bytes
graph - Available bytes
graph - Used (%)
graph - Used
table
리비전 이력
- 리비전 1Converted from grafana.com revision 1JSON 다운로드
이 대시보드 평가하기
평가하려면 로그인이 필요합니다.댓글 0개
아직 댓글이 없습니다.