Page History

...

Access the Advanced Query Monitor Configuration window

You can access the Advanced Query Monitor Configuration window (click image to view full size) by right-clicking the appropriate monitored SQL Server instance, and then selecting Properties. Click Query Monitor when SQL Diagnostic Manager displays the Monitored SQL Server Properties window, and then click Advanced.

Anchor
queryexclude queryexclude

Using Query Monitor exclusion filtering

Excluding data from your Query Monitor trace helps filter out information that is not important for the task at hand. SQL Diagnostic Manager allows you to filter specific applications, databases, or SQL text and also exclude the SQL Diagnostic Manager queries from the results. When adding multiple items to exclude, use a semi-colon (;) between items of the same type. You can also use a percent character (%) as a wildcard.

...

1. On the Queries view for the server you want to exclude data from, press the Configure Query Monitor button.
2. Click Advanced.
3. Enter your filter information in the Exclude fields, using (;) to separate items and (%) as a wildcard.
4. Click OK.

Anchor
queryinclude queryinclude

Using Query Monitor inclusion filtering

SQL Diagnostic Manager allow you to set Query Monitor inclusion filters. You can choose the applications, databases, and SQL text you want to include in the Query Monitor trace and SQL Diagnostic Manager stores only queries that match these inclusion filtering criteria. When adding multiple items to include, use a semi-colon (;) between items of the same type. You can also use a percent character (%) as a wildcard.

...