Page History
...
- In the Navigation page, click Servers .
- Right-click the appropriate SQL server instance, and then select Configure Alerts .
- Select the metric for which you want to configure an alert.
- Click Advanced .
- If you want to trigger an alert for certain text , type the text in the appropriate field. Use semicolons to separate names and a percent (%) character as a wildcard.
- If you want to trigger an alert for a certain regular expression , type the expression in the appropriate field. Type only one regular expression per line.
- Click OK .
- To accept these changes, click OK .
To use Alert Configuration Templates to enter text or a regular expression to trigger an alert:
- Click Tools > Alert Configuration Templates .
- Click New or select an existing template, and then click View/Edit .
- If you clicked New , type a name, and then click Edit Configuration .
- If you clicked View/Edit , click Edit Configuration .
- Select the metric for which you want to configure an alert.
- Click Advanced .
- If you want to trigger an alert for certain text , type the text in the appropriate field. Use semicolons to separate names and a percent (%) character as a wildcard.
- If you want to trigger an alert for a certain regular expression , type the expression in the appropriate field. Type only one regular expression per line.
- Click OK .
- If you want SQL Diagnostic Manager to replicate your edits to every monitored SQL Server instance , click Yes .
- To accept these changes, click OK .
Limit the size of a log that SQL Diagnostic Manager reads
...
- View the Alert Configuration for your monitored SQL Server instance.
- Select either the SQL Server Agent Log or the SQL Server Error Log alert, and then click Advanced .
- In the Alert Filters tab, adjust the Size (MB) field based on what you want for your log size limit.
- Click OK , and then click Apply .
- Click OK in the confirmation message if you want to apply your change to any other SQL Server instances, or click No .
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...