Page History
SQL Diagnostic Manager provides several options to fine-tune your prescriptive analysis results. You can apply filters that allow you to focus on a specific application or database. You can also reduce analysis "noise" by blocking recommendations and databases for changes that you do not plan to make in your environment.
Apply filters
To apply filters in your analysis results:
...
Block your recommendations
To block recommendations from appearing in your analysis:
...
- Right-click the appropriate SQL Server instance from the Servers tree and select Properties.
- Select Analysis Configuration when SQL Diagnostic Manager displays the Monitored SQL Server Properties window.
- Click Advanced Settings to access the Server Settings window.
- Select the Block Recommendations tab.
- Select the Block check-box next to each of the recommendations you want to block from future analyses.
- Click OK.
...
Info |
---|
Blocking a recommendation removes it from all future analyses results for this registered instance. |
...
- Right-click the appropriate SQL Server instance from the Servers tree and select Properties.
- Select Analysis Configuration when SQL Diagnostic Manager displays the Monitored SQL Server Properties window.
- Click Advanced Settings to access the Server Settings window.
- Select the Block Databases tab.
- Select the Block check box next to each of the databases you want to block from future analyses.
- Click OK.
...
Info |
---|
Blocking a database removes it from all future analyses results for this registered instance. |
...
Scroll pdf ignore |
---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |