Page History
On the Select categories section, you can select one or more of the following performance categories for use in the detailed analysis:
General
Disaster Recovery
...
, System Page File, System Upgrade Suggestion, and Virtual Log Files.
| Note |
|---|
The System Page Files, System Upgrade Suggestion, and Virtual Log Files performance categories are not available in SQL Diagnostic Manager 10.0. |
...
Identifies any long-running open transactions and determines whether the associated T-SQL code SQL code needs corrections to improve performance.
...
Identifies any waits that are affecting SQL Server SQL Server performance.
Resources
Disk
Detects whether disk settings and associated problems are affecting SQL Server SQL Server performance.
Memory
Examines the server memory settings and determines whether they affect performance.
...
Detects network problems or configuration settings that affect SQL Server SQL Server performance.
Processor
Detects processor problems and associated configuration settings.
...
Identifies which database configuration settings improve SQL Server SQL Server performance.
Security
Identifies non-optimal security settings on the SQL Server SQL Server instance.
Server Configuration
Detects server configuration settings that can decrease the performance of your SQL Server SQL Server instance.
Workload
Index Optimization
Determines whether index settings or problems with the indexes themselves are negatively affecting SQL Server SQL Server performance.
Query Optimization
Detects query problems that negatively affect your SQL Server SQL Server performance.
| Info |
|---|
The Index Optimization and Query Optimization categories return heavy recommendations if you run a workload analysis and they return light recommendations if you run a regular analysis. |