Return
-
Title
Sybase MDA and Sybase RS rule to collection mapping -
Description
What Sybase MDA and Sybase RS agent collections need to be enabled for specific alarms to work?
-
Resolution
Rule to collection mapping for the Sybase MDA and Sybase RS agents.
Sybase MDA
Rule Description Topology Related Collection Agent_Error_Messages Alerts when an error message arrives from the agent. Sybase_MDA_AgentErrorMessages AgentErrorMessages ASE_Server_status Alerts when the status of the ASE is not normal. Sybase_MDA_SybaseServerStatus SybaseServerStatus Backup_Error_Log Reports the messages in the Backup error log matching the patterns in the Log Filter List in the ASP. Sybase_MDA_BackupErrorlog BackupErrorLog Backup_Server_Status Reports the status of the backup server. Sybase_MDA_SybaseServerStatus SybaseServerStatus Benchmark_Times Reports when the elapsed time is higher than average. Sybase_MDA_BenchmarkTimes BenchmarkTimes Blocked_User Alerts if a user is blocked for more than ASP determined number of seconds Sybase_MDA_UsersBlocked UsersBlocked Cache_Efficiency Determines the hit rate for each data cache. Sybase_MDA_DataCacheDetail DataCacheDetail Connection_Usage Alerts when the number of connections in use exceeds configurable threshold Sybase_MDA_ResourcesInUse ResourcesInUse Database_Error_Log Reports the messages in the ASE error log matching the patterns in the Log Filter List in the ASP. Sybase_MDA_DatabaseErrorlog DatabaseErrorLogDetails Database_Error_Log_Details Reports the messages in the ASE error log with severity 17-21 as Critical and 22 and higher as Fatal. Sybase_MDA_DatabaseErrorlogDetails DatabaseErrorLogDetails Database_Error_Log_Details_BySeverity Sybase_MDA_DatabaseErrorlogDetails DatabaseErrorLogDetails Database_Space Reports when the space used on a segment within a database exceeds the defined threshold. Sybase_MDA_DatabaseSegmentSpace DBSegmentSpace Database_Status Notifies the database administrator if a database status is abnormal. Sybase_MDA_DatabaseStatus DBStatus DB_Error_Log_Size Alerts when the Sybase ASE Error Log exceeds the threshold. Sybase_MDA_ResourcesInUse ResourcesInUse DB_Space_TransLog Determines when the space used on a transaction log within a database exceeds the threshold defined. Sybase_MDA_DatabaseTransLogSpace DBLogSpace DeadLocks Notifies the database administrator if the total number of deadlocks to lock requests exceeds 1%. Sybase_MDA_Locks Locks Disk_SemaphoreDelays Determines the number of times an I/O was delayed when a semaphore was not available. Sybase_MDA_DiskIOSummary DiskIOSummary Engine_Busy Determines when the average engine utilization is approaching saturation. Sybase_MDA_EngineSummary EngineSummary Engine_Went_Down Monitors the engines went down. Sybase_MDA_EngineDetail EngineDetail Lock_Requests_Waited Monitors the amount of lock contention. Sybase_MDA_Locks Locks Lock_Timeouts Notifies the database administrator when a row or page lock was held too long and exceeded the system wait parameter. Sybase_MDA_Locks Locks Lock_Usage Monitors the amount of locks used as a percentage of the number configured Sybase_MDA_ResourcesInUse ResourcesInUse Long_Running_Trans Monitors the long transactions. The transactions length defines in ASP Sybase_MDA_LongRunningTrans LongRunningTrans MetaData_OpenDbs_Reu Warns when a metadata descriptor was reused in order to accommodate an increase in open databases in the server Sybase_MDA_MetaDataCache MetaDataCache MetaData_OpenDbs_Usa Warns when the number of open databases is higher than the threshold. Sybase_MDA_MetaDataCache MetaDataCache MetaData_OpenInd_Reu Warns when a metadata descriptor was reused in order to accommodate an increase in open indexes in the server. Sybase_MDA_MetaDataCache MetaDataCache MetaData_OpenInd_Usa Warns when the number of open indexes is higher than the threshold. Sybase_MDA_MetaDataCache MetaDataCache MetaData_OpenObj_Reu Warns when a metadata descriptor was reused in order to accommodate an increase in open objects in the server. Sybase_MDA_MetaDataCache MetaDataCache MetaData_OpenObj_Usa Warns when the number of open objects is higher than the threshold. Sybase_MDA_MetaDataCache MetaDataCache Parallel_Queries_Alt Determines the number of requests for which the number of worker processes was reduced due to lack of available worker process. Sybase_MDA_ParallelQuery ParallelQuery Procedure_Cache_HR Determines the percentage of procedure requests resulting in reads from disk. Sybase_MDA_ProcedureCache ProcedureCache ServerCfgChangesInt Alerts when an Adaptive Server configuration parameter changes. Sybase_MDA_SybaseConfigChanges SybaseConfigChanges ServerCfgChangesStr Alerts when an Adaptive Server configuration parameter changes. Sybase_MDA_SybaseConfigChanges SybaseConfigChanges Spinlocks Contention Value Sybase_MDA_Spinlocks Spinlock TempDb_Space Alerts when the space used on a segment within a temporary database exceeds the threshold defined. Sybase_MDA_DatabaseSegmentSpace DBSegmentSpace TmpDb_Space_TranLog Alerts when the space used on a transaction log within a temporary database exceeds the threshold defined. Sybase_MDA_DatabaseTransLogSpace DBLogSpace UserLogCache Determines the percentage of user log cache flushes resulting from the cache becoming full. Sybase_MDA_UsersLogCache UsersLogCache Sybase RS
Rule Description Topology Related Collection RS_AgentErrorMessage This rule alerts when an error message arrives from the agent. Sybase_RS_RS_AgentErrorMessage RSAgentErrorMessage RS_ConnectionAvail This rule alerts when a Replication Server's available connections are less than a certain number. Sybase_RS_RS_ConnectionSummary RS_Connection_Detail RS_ConnectionLimbo This rule alerts when a Replication Server's limbo connections is more than a percent of the total connections Sybase_RS_RS_ConnectionSummary RS_Connection_Detail RS_ConnectionStatus This rule alerts when a Replication Server Connection is not in a desired state. Sybase_RS_RS_ConnectionDetail RS_Connection_Detail RS_ErrorlogMsg This rule alerts when any number of error messages is detected in the Replication Server error log. Sybase_RS_RS_ErrorlogSummary RSErrorlogDetail RS_ExceptionsFound This rule alerts when Orphan or Error Transaction Exceptions are found. Sybase_RS_RS_ExceptionsDetail RSExceptionsDetail RS_Health This rule alerts when the health of the Replication Server is not normal. Sybase_RS_RS_Health RSHealth RS_Latency This rule alerts when a Replication Server latency is greater than the threshold. Sybase_RS_RS_Latency RSTicket RS_LatencyNegative This rule alerts when the latency is negative. Sybase_RS_RS_Latency RSTicket RS_LatencyStale This rule alerts when a Replication Server's latency is stale. Sybase_RS_RS_Latency RSTicket RS_PartitionSpaceUse This rule alerts when a Replication Server partition space exceeds the threshold in Foglight Sybase_RS_RS_PartitionSpaceUsed RSPartitionStatusDetail RS_PartitionStatus This rule alerts when a Replication Server partition status is not normal. Sybase_RS_RS_PartitionStatusDetail RSPartitionStatusDetail RS_RepAgentStatus This rule alerts when a Replication Agent status is not normal. Sybase_RS_RS_RepAgentStatus RSRepAgentStatus RS_SQMDuplicateMsgs This rule alerts when a SQM thread on a Replication Server finds and ignores duplicate messages Sybase_RS_RS_SQM_Trend RSSQMTrend RS_ThreadsDown This rule alerts when a Replication Server thread is down. Sybase_RS_RS_ThreadsDownDetail RSThreadsDownDetail RS_ThreadsInactive This rule alerts when a Replication Server thread is inactive. Sybase_RS_RS_ThreadsDownDetail RSThreadsDownDetail RS_ThreadsProblems This rule alerts when a Replication Server thread is down or suspended. Sybase_RS_RS_ThreadSummary RS_Thread_Summary RS_ThreadsSuspended This rule alerts when a Replication Server thread is suspended. Sybase_RS_RS_ThreadsDownDetail RSThreadsDownDetail -
Defect ID
FGDBSYB-I-4