Page History
...
Prescriptive analysis targets some of the most common areas of SQL Server performance problems, such as queries, server configuration, security, database objects, memory, and more. Its easy to work with the interface, it makes this feature accessible to a broad range of users such as the less experienced DBA or the developer in need of testing database performance.
| Info |
|---|
SQL Diagnostic Manager now includes new recommendations for Azure and Amazon RDS instances. |
Access the Analyze tab
SQL Diagnostic Manager provides two paths to access the Analyze tab. The first access path is by selecting the appropriate monitored SQL Server SQL Server instance, and then clicking the Analyze tab where you can run a regular analysis or a workload analysis. The second access path is by expanding the Servers tree, selecting a specific SQL Server instance, and then clicking Analyze.
...
- Run a prescriptive analysis on your SQL Server on-demand or schedule a regular analysis of your SQL Server instance.
- Run a workload analysis on-demand.
- Fine-tune your analysis.
- Identify a problem and optimize scripts.
- View your prescriptive analysis results.
- Access key Newsfeed commands.
| Info |
|---|
Prescriptive analysis uses the best method to collect query data according to the SQL Server version. If your monitored server is SQL Server 2008 or a later version, Extended Events is used in place of SQL Trace. |
| Tip |
|---|
If you do not wish to run a full analysis of your SQL Server, you can diagnose individual queries. For more information, see Diagnose queries. |