Running SQL Queries from the Administration Console
You can run database queries directly against the PPM database schema from the Administration Console.
Note: For information about how to run SQL queries from the PPM Workbench, see Running SQL Statements from the PPM Workbench.
Running SQL statements from the Administration Console is essentially the same as running them from the PPM Workbench. However, from the Administration Console you can run a statement that ends with a semicolon (;).
To run a SQL statement (select statement only) from the Administration Console:
-
In the Administration Console Actions panel, select Administration Task > SQL Runner.
-
In the SQL Statement box, type the select statement to run against the PPM database.
-
Click Run SQL.
The Results table displays the query results in numbered rows.
-
To test the connection speed between the PPM Server and the PPM database, click the Ping DB button.
Note: Because the Administration Console uses a Web Interface, it ignores the connection time between the web client and the PPM Server.
SQL Statement Execution Details
The Execution Details section of the SQL runner page displays the following:
-
The Server Roundtrip value represents the time spent (in milliseconds) between the PPM Server and the PPM database.
-
The SQL Execution value represents the duration of the SQL run in milliseconds.
-
The ResultSet Extraction value represents the amount of time (in milliseconds) required to extract results from the results set.
-
The Total Time value represents the amount of time (in milliseconds).
Note: In Workbench, the Server Roundtrip value represents the time spent between the PPM Workbench client and the PPM Server). In either context, the measure is a good indication of measure network latency.
Exporting SQL Run Results
You can export the SQL run results in either comma-separated or text format. If you do export the results, any sorting and grouping you perform from the Administration Console is discarded. Only the raw results are exported.
To export the data to a file in comma-separated format:
-
Click Open as CSV.
The Administration Console displays the message "Do you want to open or save
ppm_sql_<date>_<time>.csv(<size> KB) from<Server_IP_Address>?" -
Click Open, Save, Save as, or Save and open.
To export the data to a text file:
-
Click Open as CSV.
The Administration Console displays the message "Do you want to open or save
ppm_sql_<date>_<time>.txtfrom <Server_IP_Address>?" -
Click Open, Save, Save as, or Save and open.
