12,509 Metrics install automatically if you have Redgate Monitor installed.
If you are using Redgate’s SQL Server monitoring tool, Redgate Monitor, you can instantly install and run this metric on your servers.
This metric is not important in its own right, and viewing the data points on the Analysis page will not provide useful information. The metric is a necessary step in order to achieve the key purpose of this metric, which is to create an alert that will be raised when something is added to the schema, or the existing schema is modified.
Note: If you delete a schema object such as a table, constraint or index, an alert is not raised.
Metric definition
Name
Schema modified
Description
Spikes indicate that something has been added to the database schema, or the existing schema has been modified. A spike will not occur if a schema object is deleted. For more information, see http://msdn.microsoft.com/en-gb/library/ms190324.aspx.
The T-SQL query that will collect data
Instances to collect from
the relevant instance
Databases to collect from
the database you're interested in
Collection frequency
1800
Use collected or calculated values
Check the Use a calculated rate of change between collections check box
Metric collection
Enabled
Alert definition
Alert name
Schema modified
Description
Raise an alert when the metric value goes
above the defined threshholds
Default threshold values
| High: | Turn off check box |
| Medium: | 0 |
| Low: | Turn off check box |
Note: These thresholds are intended as guideline values. If they seem too high or too low for your environment, replace them with values more suited to your server performance.
Raise an alert when the threshold is passed for
1 collection
Alert is
Enabled
