Agresso – missing user indexes


Job details

Name: Agresso – missing user indexes
Platform: Sqlserver
Category: Agresso
Description: Checks if there are any missing user indexes in the agresso database by comparing records in dbo.asysindex and sys.indexes tables.
Long description: Checks if there are any missing user indexes in the agresso database by comparing records in dbo.asysindex and sys.indexes tables.
Version: 1.31
Default schedule: 35 7 1-5 *
Requires engine install: Yes
Compatibility tag: .[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.

Job Summary

SELECT asys.index_name FROM dbo.asysindex as asys
LEFT JOIN sys.indexes as sys ON asys.index_name = sys.name
WHERE sys.name IS NULL

Details and Operations

Dependencies and Procedures

Handling Outputs

Database Table Name Index Name Column List Unique

bac.. | SELECT * FROM agresso_missing_user_idx_tab |

*Reports are generated according to the scheduled times within dbWatch, streamlining the process for administrators.

Environmental Requirements and Constraints

Upgrade Implications

Custom Configuration

This comprehensive monitoring solution is crucial for maintaining the efficient operation of Agresso databases, making it a significant asset in a DBA‘s toolkit.