3.15 Database Objects

The metrics in this category provide information regarding each table, view, stored procedure, extended stored procedure, log, rule, default, trigger, check constraint, referential constraint, computed column, function-based index key, and (in tempdb only) temporary object, and other forms of compiled objects. It also contains one row for each partition condition ID when object type is N.

Collection Frequency - Every 24 hours

Table 3-16 Database Objects Metrics

Metric	Description	Default Warning Threshold	Default Critical Threshold	Alert Text
Number of changes in the schema	Count of changes in the schema of an object (incremented if a rule or default is added). For this metric, you can set different warning and critical threshold values for each "Object Name" object. If warning or critical threshold values are currently set for any "Object Name" object, those thresholds can be viewed on the Metric Detail page for this metric. To specify or change warning or critical threshold values for each "Object Name" object, use the Edit Thresholds page.	Not Defined	Not Defined	The total number of changes in the schema are %SchemaCnt%. It has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.

Metric

Description

Default Warning Threshold

Default Critical Threshold

Alert Text

Number of changes in the schema

Count of changes in the schema of an object (incremented if a rule or default is added).

For this metric, you can set different warning and critical threshold values for each "Object Name" object. If warning or critical threshold values are currently set for any "Object Name" object, those thresholds can be viewed on the Metric Detail page for this metric. To specify or change warning or critical threshold values for each "Object Name" object, use the Edit Thresholds page.

Not Defined

The total number of changes in the schema are %SchemaCnt%. It has crossed warning (%warning_threshold%) or critical (%critical_threshold%) threshold.

Table 3-17 Database Objects Metrics

Metric	Description and User Action
Stored Procedure ID of a Delete Trigger	Stored procedure ID of a delete trigger if the entry is a table. Table ID if the entry is a trigger.
Stored Procedure ID of a Insert Trigger	Stored procedure ID of a table's insert trigger if the entry is a table.
For Release 6 Object ID	For System Monitoring Plug-In for Sybase Adaptive Server Enterprise (ASE) Release 6 (1.0.1.0.0) Object ID.
Object Type	One of the following object types: C – computed column D – default F – SQLJ function L – log N – partition condition P – Transact-SQL or SQLJ procedure PR – prepare objects (created by Dynamic SQL) R – rule RI – referential constraint S – system table TR – trigger U – user table V – view XP – extended stored procedure.
Object Name	The name of the object.
Login Name of user who created the object	Login name of user who created the object.