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.
Based on the chosen categories, SQL Doctor analyses your target SQL Server instance to gather the appropriate metrics and determine which recommendations match the server's current performance issues. The more categories you pick, the longer the analysis needs to run to ensure all relevant data has been collected and thoroughly analyzed.
You can access the Select categories tab of the Analysis Wizard by clicking Analyze Server, selecting the appropriate SQL Server instance, and clicking Next.
On the Select categories tab, you can select one or more of the following performance categories for use in the detailed analysis:
Detects any processes that are blocking other processes.
Identifies which database configuration settings improve SQL Server performance.
Detects any deadlocks on the SQL Server instance.
Detects whether disk settings and associated problems are affecting SQL Server performance.
Detects any database and transaction log backup issues such as failures or skips, overdue integrity checks, and corruption issues.
Determines whether index settings or problems with the indexes themselves are negatively affecting SQL Server performance.
Identifies any long-running jobs.
Examines the server memory settings and determines whether they affect performance.
Detects network problems or configuration settings that affect SQL Server performance.
Identifies any long-running open transactions and determines whether the associated T-SQL code needs corrections to improve performance.
Detects processor problems and associated configuration settings.
Detects query problems that negatively affect your SQL Server performance.
Identifies non-optimal security settings on the SQL Server instance.
Detects server configuration settings that can decrease the performance of your SQL Server instance.
Identifies any waits that are affecting SQL Server performance.
IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
---|