Data reference for Azure Monitor for SAP solutions

This article provides a reference of log data collected to analyze the performance and availability of Azure Monitor for SAP solutions. See Monitor SAP on Azure for details on collecting and analyzing monitoring data for SAP on Azure.

Metrics

Azure Monitor for SAP solutions doesn't support metrics.

Azure Monitor logs tables

This section refers to all of the Azure Monitor Logs Kusto tables relevant to Azure Monitor for SAP solutions and available for query by Log Analytics. Azure Monitor for SAP solutions uses custom logs. The schemas for some tables are defined by third-party providers, such as SAP. Here are the current custom logs for Azure Monitor for SAP solutions with links to sources for more information.

SapHana_HostConfig_CL

For more information, see M_LANDSCAPE_HOST_CONFIGURATION System View in the SAP HANA SQL and System Views Reference.

SapHana_HostInformation_CL

For more information, see M_HOST_INFORMATION System View in the SAP HANA SQL and System Views Reference.

SapHana_SystemOverview_CL

For more information, see M_SYSTEM_OVERVIEW System View in the SAP HANA SQL and System Views Reference.

SapHana_LoadHistory_CL

For more information, see M_LOAD_HISTORY_HOST System View in the SAP HANA SQL and System Views Reference.

SapHana_Disks_CL

For more information, see M_DISKS System View in the SAP HANA SQL and System Views Reference.

SapHana_SystemAvailability_CL

For more information, see M_SYSTEM_AVAILABILITY System View in the SAP HANA SQL and System Views Reference.

SapHana_BackupCatalog_CL

For more information, see:

SapHana_SystemReplication_CL

For more information, see M_SERVICE_REPLICATION System View in the SAP HANA SQL and System Views Reference.

Prometheus_OSExporter_CL

For more information, see prometheus / node_exporter on GitHub.

Prometheus_HaClusterExporter_CL

For more information, see ClusterLabs/ha_cluster_exporter.

MSSQL_DBConnections_CL

For more information, see:

MSSQL_SystemProps_CL

For more information, see:

MSSQL_FileOverview_CL

For more information, see sys.database_files (Transact-SQL).

MSSQL_MemoryOverview_CL

For more information, see sys.dm_os_memory_clerks (Transact-SQL).

MSSQL_Top10Statements_CL

For more information, see:

MSSQL_IOPerformance_CL

For more information, see sys.dm_io_virtual_file_stats (Transact-SQL).

MSSQL_TableSizes_CL

For more information, see sys.dm_db_partition_stats (Transact-SQL).

MSSQL_BatchRequests_CL

For more information, see sys.dm_os_performance_counters (Transact-SQL).

MSSQL_WaitPercs_CL

For more information, see sys.dm_os_wait_stats (Transact-SQL).

MSSQL_PageLifeExpectancy2_CL

For more information, see sys.dm_os_performance_counters (Transact-SQL).

MSSQL_Error_CL

For more information, see sys.fn_xe_file_target_read_file (Transact-SQL).

MSSQL_CPUUsage_CL

For more information, see SQL Server Operating System Related Dynamic Management Views (Transact-SQL).

MSSQL_AOOverview_CL

For more information, see sys.availability_groups (Transact-SQL).

MSSQL_AOWaiter_CL

For more information, see sys.dm_exec_requests (Transact-SQL).

MSSQL_AOWaitstats_CL

For more information, see sys.dm_os_wait_stats (Transact-SQL).

MSSQL_AOFailovers_CL

For more information, see:

MSSQL_BckBackups2_CL

For more information, see: backupset (Transact-SQL).

MSSQL_BlockingProcesses_CL

For more information, see sys.sysprocesses (Transact-SQL).

Next steps