SQL Diagnostics in Data Management (DMS) analyzes SQL statements directly in the SQLConsole and returns detected issues with optimization suggestions. Run a diagnosis before executing queries in production to catch performance problems early.
Prerequisites
Before you begin, ensure that you have:
Access to the DMS console V5.0
A database connected to DMS
Diagnose a SQL statement
Go to the DMS console V5.0.
In the top navigation bar, choose SQL Console > SQL Console.
In the Please select the database first dialog box, enter a keyword to search for a database, select the database from the search results, and then click Confirm.
On the SQLConsole tab, enter the SQL statements you want to diagnose, and then click SQL Diagnostics.
In the SQL Diagnosis dialog box, review the results.
Understand the diagnosis results
The SQL Diagnosis dialog box returns two categories of output:
Detected issues: Problems identified in your SQL statements.
Optimization suggestions: Specific actions to resolve each detected issue.
Review each suggestion and apply the ones relevant to your workload before running the statements in production.