The Advanced Query Wait Statistics Configuration window allows you to filter out applications, databases, SQL text from the Query Waits Statistics collection, and exclude specific SQL Diagnostic Manager queries as well as limit the number of rows to be collected at a time. Filtering allows you to improve the results you see in the Query Waits view and reduce the impact of the Query Wait trace on your server.
Overly complex filters of SQL Text using Extended Events can cause high loads on the monitored instance due to a known Microsoft defect.
Access the Advanced Query Wait Statistics Configuration window
You can access the Advanced Query Wait Statistics Configuration window by right-clicking the appropriate monitored SQL Server instance, and then selecting Properties. Click Wait Monitoring when SQL Diagnostic Manager displays the Monitored SQL Server Properties window, and then click Filter Options.
When using Query Wait filtering, take into account that Exclude takes precedence over Include.
Using Query Wait filtering
Excluding data from your Query Waits Statistics collection helps filter out information that is not important for the task at hand. SQL Diagnostic Manager allows you to filter specific applications, databases, SQL text and also exclude the SQL Diagnostic Manager queries from the results or limit the number of rows to be collected at a time. When including multiple items to exclude, use a semi-colon (;) between items of the same type. You can also use a percent character (%) as a wildcard.
To exclude data from your Query Wait Statistics collection while in the Queries view:
- On the Queries Waits view for the server you want to exclude data from, press the Configure button.
- Click Filter Options.
- Enter your filter information in the provided fields, using (;) to separate items and (%) as a wildcard.
- Click OK.