Microsoft SCOM

Microsoft System Center Operations Manager (SCOM) is an agent-based monitoring system for Microsoft Windows operating system and applications that run on it.

Statistics collected by SCOM agents are processed by the SCOM server and stored in the Operations and DWH databases.

Axibase Collector queries PerformanceDataAllView in the SCOM Operations database view every 5-30 minutes to offload incremental data into Axibase Time Series Database for long-term retention and operations analytics.

See SCOM integration instructions for technical details.

SCOM Server Portal

Launch live SCOM Server Portal in Axibase Chart Lab.

SCOM SQL Server Portal

Launch live SCOM SQL Server Portal in Axibase Chart Lab.

Collected SCOM Metrics

SQL Server

sqlserver.msas:connection.current_connections
sqlserver.msas:data_mining_model_processing.current_models_processing
sqlserver.msas:data_mining_prediction.concurrent_dm_queries
sqlserver.msas:memory.memory_limit_high_kb
sqlserver.msas:processing.rows_read_sec
sqlserver.msas:processing.rows_written_sec
sqlserver.msas:storage_engine_query.avg_time_query
sqlserver.msas:storage_engine_query.bytes_sent_sec
sqlserver.msas:storage_engine_query.rows_sent_sec
sqlserver.mssql.rtc:broker_activation.stored_procedures_invoked_sec
sqlserver.mssql.rtc:broker_activation.task_limit_reached
sqlserver.mssql.rtc:broker_activation.task_limit_reached_sec
sqlserver.mssql.rtc:broker_activation.tasks_aborted_sec
sqlserver.mssql.rtc:broker_activation.tasks_started_sec
sqlserver.mssql.rtc:broker_dbm_transport.message_fragment_receives_sec
sqlserver.mssql.rtc:broker_dbm_transport.message_fragment_sends_sec
sqlserver.mssql.rtc:broker_dbm_transport.open_connection_count
sqlserver.mssql.rtc:broker_dbm_transport.receive_ios_sec
sqlserver.mssql.rtc:broker_dbm_transport.send_ios_sec
sqlserver.mssql.rtc:broker_statistics.broker_transaction_rollbacks
sqlserver.mssql.rtc:broker_statistics.enqueued_messages_sec
sqlserver.mssql.rtc:broker_statistics.enqueued_transport_msgs_sec
sqlserver.mssql.rtc:broker_statistics.sql_receives_sec
sqlserver.mssql.rtc:broker_statistics.sql_sends_sec
sqlserver.mssql.rtc:buffer_manager.buffer_cache_hit_ratio
sqlserver.mssql.rtc:databases.transactions_sec
sqlserver.mssql.rtc:general_statistics.logins_sec
sqlserver.mssql.rtc:general_statistics.user_connections
sqlserver.mssql.rtc:locks.lock_requests_sec
sqlserver.mssql.rtc:locks.lock_timeouts_sec
sqlserver.mssql.rtc:locks.lock_waits_sec
sqlserver.mssql.rtc:locks.number_of_deadlocks_sec
sqlserver.mssql.rtc:sql_statistics.sql_compilations_sec
sqlserver.mssql.rtc:sql_statistics.sql_re-compilations_sec
sqlserver.mssql.rtc_database.db_allocated_size_mb
sqlserver.mssql.rtc_database.db_total_free_space_%
sqlserver.mssql.rtc_database.db_total_free_space_mb
sqlserver.mssql.rtc_database_db_log_file.db_log_file_allocated_space_left_%
sqlserver.mssql.rtc_database_db_log_file.db_log_file_allocated_space_left_mb
sqlserver.mssql.rtc_database_db_log_file.db_log_file_free_space_%
sqlserver.mssql.rtc_database_db_log_file.db_log_file_free_space_mb
sqlserver.mssql.rtc_database_file_group.db_file_group_allocated_space_left_%
sqlserver.mssql.rtc_database_file_group.db_file_group_allocated_space_left_mb
sqlserver.mssql.rtc_database_file_group.db_file_group_free_space_%
sqlserver.mssql.rtc_database_file_group.db_file_group_free_space_mb
sqlserver.mssql.rtc_database_file_group_db_file.db_file_allocated_space_left_%
sqlserver.mssql.rtc_database_file_group_db_file.db_file_allocated_space_left_mb
sqlserver.mssql.rtc_database_file_group_db_file.db_file_free_space_%
sqlserver.mssql.rtc_database_file_group_db_file.db_file_free_space_mb
sqlserver.sqlserver:broker_activation.stored_procedures_invoked_sec
sqlserver.sqlserver:broker_activation.task_limit_reached
sqlserver.sqlserver:broker_activation.task_limit_reached_sec
sqlserver.sqlserver:broker_activation.tasks_aborted_sec
sqlserver.sqlserver:broker_activation.tasks_started_sec
sqlserver.sqlserver:broker_dbm_transport.message_fragment_receives_sec
sqlserver.sqlserver:broker_dbm_transport.message_fragment_sends_sec
sqlserver.sqlserver:broker_dbm_transport.open_connection_count
sqlserver.sqlserver:broker_dbm_transport.receive_ios_sec
sqlserver.sqlserver:broker_dbm_transport.send_ios_sec
sqlserver.sqlserver:broker_statistics.broker_transaction_rollbacks
sqlserver.sqlserver:broker_statistics.enqueued_messages_sec
sqlserver.sqlserver:broker_statistics.enqueued_transport_msgs_sec
sqlserver.sqlserver:broker_statistics.sql_receives_sec
sqlserver.sqlserver:broker_statistics.sql_sends_sec
sqlserver.sqlserver:buffer_manager.buffer_cache_hit_ratio
sqlserver.sqlserver:databases.transactions_sec
sqlserver.sqlserver:general_statistics.logins_sec
sqlserver.sqlserver:general_statistics.user_connections
sqlserver.sqlserver:locks.lock_requests_sec
sqlserver.sqlserver:locks.lock_timeouts_sec
sqlserver.sqlserver:locks.lock_waits_sec
sqlserver.sqlserver:locks.number_of_deadlocks_sec
sqlserver.sqlserver:sql_statistics.sql_compilations_sec
sqlserver.sqlserver:sql_statistics.sql_re-compilations_sec
sqlserver.sqlserver:ssis_pipeline_10.0.buffers_spooled
sqlserver.sqlserver:ssis_pipeline_10.0.rows_read
sqlserver.sqlserver:ssis_pipeline_10.0.rows_written
sqlserver.sqlserver_database.db_allocated_size_mb
sqlserver.sqlserver_database.db_total_free_space_%
sqlserver.sqlserver_database.db_total_free_space_mb
sqlserver.sqlserver_database_db_log_file.db_log_file_allocated_space_left_%
sqlserver.sqlserver_database_db_log_file.db_log_file_allocated_space_left_mb
sqlserver.sqlserver_database_db_log_file.db_log_file_free_space_%
sqlserver.sqlserver_database_db_log_file.db_log_file_free_space_mb
sqlserver.sqlserver_database_file_group.db_file_group_allocated_space_left_%
sqlserver.sqlserver_database_file_group.db_file_group_allocated_space_left_mb
sqlserver.sqlserver_database_file_group.db_file_group_free_space_%
sqlserver.sqlserver_database_file_group.db_file_group_free_space_mb
sqlserver.sqlserver_database_file_group_db_file.db_file_allocated_space_left_%
sqlserver.sqlserver_database_file_group_db_file.db_file_allocated_space_left_mb
sqlserver.sqlserver_database_file_group_db_file.db_file_free_space_%
sqlserver.sqlserver_database_file_group_db_file.db_file_free_space_mb

SCOM Windows Server

server.logicaldisk.%_free_space
server.logicaldisk.%_idle_time
server.logicaldisk.avg_disk_sec_transfer
server.logicaldisk.current_disk_queue_length
server.logicaldisk.free_megabytes
server.memory.%_committed_bytes_in_use
server.memory.available_mbytes
server.memory.free_system_page_table_entries
server.memory.pages_sec
server.memory.percentmemoryused
server.memory.pool_nonpaged_bytes
server.memory.pool_paged_bytes
server.network_adapter.percentbandwidthusedtotal
server.network_interface.bytes_total_sec
server.network_interface.current_bandwidth
server.paging_file.%_usage
server.processor.%_interrupt_time
server.processor.%_processor_time
server.processor_information.%_processor_time
server.system.processor_queue_length

Active Directory

ad.directoryservices.dra_inbound_bytes_compressed_between_sites_after_compression_sec
ad.directoryservices.dra_inbound_bytes_compressed_between_sites_before_compression_sec
ad.directoryservices.dra_inbound_bytes_not_compressed_within_site_sec
ad.directoryservices.dra_inbound_bytes_total_sec
ad.directoryservices.dra_outbound_bytes_compressed_between_sites_after_compression_sec
ad.directoryservices.dra_outbound_bytes_compressed_between_sites_before_compression_sec
ad.directoryservices.dra_outbound_bytes_not_compressed_within_site_sec
ad.directoryservices.dra_outbound_bytes_total_sec
ad.directoryservices.ds_search_sub-operations_sec
ad.directoryservices.ldap_client_sessions
ad.directoryservices.ldap_searches_sec
ad.directoryservices.ldap_udp_operations_sec
ad.directoryservices.ldap_writes_sec
ad.domain_naming_op_master.op_master_domain_naming_last_bind
ad.domain_naming_op_master.op_master_domain_naming_last_ping
ad.general_response.active_directory_last_bind
ad.general_response.global_catalog_search_time
ad.infrastructure_op_master.op_master_infrastructure_last_bind
ad.infrastructure_op_master.op_master_infrastructure_last_ping
ad.library.ad_storage.database_drive_free_space
ad.library.ad_storage.database_size
ad.library.ad_storage.log_file_drive_free_space
ad.library.ad_storage.log_file_size
ad.memory.available_bytes
ad.memory.committed_bytes
ad.memory.pages_sec
ad.pdc_op_master.op_master_pdc_last_bind
ad.pdc_op_master.op_master_pdc_last_ping
ad.process.%_processor_time
ad.process.handle_count
ad.process.private_bytes
ad.processor.%_processor_time
ad.rid_op_master.op_master_rid_last_bind
ad.rid_op_master.op_master_rid_last_ping
ad.schema_op_master.op_master_schema_last_bind
ad.schema_op_master.op_master_schema_last_ping
ad.security_system-wide_statistics.kdc_as_requests
ad.security_system-wide_statistics.kdc_tgs_requests
ad.security_system-wide_statistics.kerberos_authentications
ad.security_system-wide_statistics.ntlm_authentications
ad.server.server_sessions
ad.system.system_up_time
ad.tcpv4.connections_established
ad.tcpv6.connections_established

System Center

systemcenter.datawarehouse.opsmgr_dw_synchronization_module.avg_batch_processing_time_ms
systemcenter.datawarehouse.opsmgr_dw_synchronization_module.avg_batch_size
systemcenter.datawarehouse.opsmgr_dw_synchronization_module.batch_age_sec
systemcenter.datawarehouse.opsmgr_dw_synchronization_module.batch_size
systemcenter.datawarehouse.opsmgr_dw_synchronization_module.batches_sec
systemcenter.datawarehouse.opsmgr_dw_synchronization_module.data_items_sec
systemcenter.datawarehouse.opsmgr_dw_synchronization_module.errors_sec
systemcenter.datawarehouse.opsmgr_dw_synchronization_module.total_error_count
systemcenter.datawarehouse.opsmgr_dw_writer_module.avg_batch_processing_time_ms
systemcenter.datawarehouse.opsmgr_dw_writer_module.avg_batch_size
systemcenter.datawarehouse.opsmgr_dw_writer_module.batches_sec
systemcenter.datawarehouse.opsmgr_dw_writer_module.data_items_sec
systemcenter.datawarehouse.opsmgr_dw_writer_module.dropped_batch_count
systemcenter.datawarehouse.opsmgr_dw_writer_module.dropped_data_item_count
systemcenter.datawarehouse.opsmgr_dw_writer_module.errors_sec
systemcenter.datawarehouse.opsmgr_dw_writer_module.total_error_count
systemcenter.health_service.active_file_uploads
systemcenter.health_service.agent_processor_utilization
systemcenter.health_service.module_count
systemcenter.health_service.workflow_count
systemcenter.health_service_management_groups.bind_data_source_item_drop_rate
systemcenter.health_service_management_groups.bind_data_source_item_incoming_rate
systemcenter.health_service_management_groups.send_queue_%_used
systemcenter.health_service_management_groups.send_queue_size
systemcenter.operationsmanager.defaultuser.paging_file.%_usage
systemcenter.operationsmanager.defaultuser.paging_file.%_usage_peak
systemcenter.opsmgr_config_service.number_of_queued_requests
systemcenter.opsmgr_db_write_action_modules.avg_batch_size
systemcenter.opsmgr_db_write_action_modules.avg_processing_time
systemcenter.opsmgr_sdk_service.client_connections
systemcenter.system.system_up_time