Page History

In the Analysis Configuration tab of the Monitored SQL Server Properties window you can schedule a prescriptive analysis of your SQL Server instance and configure your analysis options.Image Removed

Image Added

Access the Analysis Configuration tab

You To can access the Analysis Configuration tab of the Monitor SQL Server Properties window by , right-clicking click the appropriate monitored SQL Server instance, select Properties, and then selecting Properties > click Analysis Configuration.

Specify analysis options

...

• Check Production Server, if your instance is being used as a production server.
• Check Online Transaction Processing (OLTP), if your instance has OLTP enabled.

Schedule an analysis

SQL Diagnostic Manager allows you to schedule a the days and time for regular prescriptive analysis and/or specify the duration of a workload analysis on your SQL Server instance. Scheduled analyses are an important way to track the health of your SQL Server environment.  For more information on this feature, see Schedule analysis.

Select categories

When configuring your analysis, you can select any combination of performance categories to focus the analysis.  Each category contains a set of performance metrics and their related recommendations.  By picking a category, you are identifying which SQL Server areas concern you most.  For additional information on the different categories, see Performance categories.

Using advanced analysis configuration options

You can choose to block recommendations and databases from the analysis, as well as apply additional filters using the options available on the Server Settings window. To access this window, click the Advanced Settingsbutton on the Analysis Configuration tab.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >

...

...