jhelmbrecht

Tivoli to Nimsoft sqlserver probe

Discussion created by jhelmbrecht on Nov 17, 2011

Hi,

 

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.

 

Server Status

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:

External value

Internal value

Description

Active

Active or 1

SQL server is active.

Inactive

Inactive

SQL server status is inactive.

Unknown

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,

 

Thank you,

 

Josh Helmbrecht

Outcomes