Name: Agresso – not registered indexes
Platform: Sqlserver
Category: Agresso
Premium package: Agresso application package
Description: Checks if there are any indexes in the agresso database which are not registered in the dbo.asysindex or dbo.aagindex tables.
Long description:
Version: 1.3
Default schedule: 25 7 1-5 *
Requires engine install: Yes
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2012’ & hasengine=‘YES’ & (engine_edition = ‘Microsoft SQL Server’ | engine_edition = ‘Azure SQL Managed Instance’)
Parameters
Name Default value Description
ignore indexes List of agresso user indexes (separated by comma) which will be ignored from beeing checked.
database name agr% Name of the database where the Agresso application is installed. You can specify a list of databases (separated by comma). You can use % (percent sign) to represent wild card characters.
return status 1 Return status value (ALARM – 2, WARNING – 1, or OK – 0) when missing agresso user indexes.

← Agent error log / Agresso blob size collector →

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment