Schema modified

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.

Install metric...

Metrics install automatically if you have SQL Monitor installed.

If you are using Redgate’s SQL Server monitoring tool, SQL 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.

Schema modified, 2.0 out of 5 based on 1 rating

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

Raised when the schema of this database is modified. If this change was not authorized, you may want to investigate further. Note: If you delete a schema object such as a table, constraint or index, an alert is not raised.

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