Page History
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.
| Warning |
|---|
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
...
- 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.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...
...