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. |
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. |