Datadog Dashboards

SQL Server Monitoring

Fair 720 downloads0 views0 commentsRevision 1Created Converted from Grafana dashboard #1883 by Marcus Efraimsson
How to import

In Datadog: Dashboards → New Dashboard → ⚙ Configure → Import dashboard JSON → paste this JSON.

Reactions

Performance and health metrics for your SQL Servers using Telegraf and Prometheus

SQL Server Monitoring

Conversion quality

Fair 72

Share of panels whose queries were translated without loss. Partial and unsupported panels keep the original PromQL in a note widget.

  • Native0
  • OpenMetrics48
  • Partial1
  • Unsupported18

Metrics without a native Datadog mapping

These metric names were kept in OpenMetrics naming. Adjust them if you collect with a native Datadog integration.

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

Unsupported panels

  • 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
Tagsprometheussql serverdatabaseshost metrics

Revisions

  • Revision 1Converted from grafana.com revision 1Download JSON

Rate this dashboard

Sign in to rate.

0 comments

No comments yet.