Page History

When configuring your analysis, you can choose which database or application workload you want to include in the analysis. Picking a database or application allows you to further fine-tune the analysis results.

You can also set the amount of time (duration, in minutes) that you want SQL Doctor to spend collecting data for your analysis. When setting the analysis duration, select a number of minutes that is proportionate to the criticality of the performance issue you are experiencing. For example, if you are experiencing a serious performance issue and you select more than one performance category to analyze, you may want to run the analysis for at least 15 minutes to ensure that you collect enough data. The more data SQL Doctor can collect for a given analysis, the greater likelihood that the resultant recommendations accurately identify and resolve the issue.

Access

...

Filters

You can access the Filters tab of the Analysis Wizard by clicking Analyze Server, completing the Select SQL instance and Select categories tabs, and then clicking Next.

Select the appropriate optionsEnter the name (%wildcard) of the Application you want to analyze in the name text box, you can limit the analysis to a single database or to all databases, specify how long you want that SQL Doctor spend collecting diagnostic data (Between 1-500 minutes), and then click Finish.

SQL Doctor provides complete SQL performance tuning. Learn more > >

...

...