A customer's requirement is SQL Server Tivoli metrics into Nimsoft. I have all of them except the following.
Does anyone have any custom templates that may complete these requirements?
Total Log Suspend
The number of processes with a status of log suspend. A process with a status of log suspend is a process that cannot complete until there is free space in the transaction log. The value format is an integer; for example, 1.
Indicates the status of the SQL server. The server status is displayed as Unknown when the collector process of the SQL Server agent is not running. The server status is displayed as Inactive when the collector process of the SQL Server agent is running, but the SQL Server is not responding to the request. The following values are also valid:
Active or 1
SQL server is active.
SQL server status is inactive.
Unknown or 0
SQL server status is unknown.
SQLServerAgent Failed Jobs
Reports any jobs run by the SQLServerAgent service that have failed in the last monitoring interval. The first time you retrieve this attribute, it returns 0. The next time you retrieve it, it returns the total number of SQLServerAgent failed jobs found in the system history tables since the first run. These jobs include replication and user-defined jobs, such as maintenance or backup tasks. Use this attribute to alert you when scheduled tasks have
Total Errors High Sev
The number of error messages with a severity level of 17 or higher that have occurred since the SQL server was started. The value format is an integer; for example,
Percent Processes Blocked The percentage of processes that are being blocked. The value format is a percentage with two decimal places allowed; for example, 4.00. This value is based on information from the sysprocesses table. The value includes all processes
Total Processes Blocked The number of processes that are being blocked. The value format is an integer; for example,