SQL SERVER LOGGING without the output, only statistics - DataDirect Connect - Products Enhancements - Progress Community

 DataDirect Connect

SQL SERVER LOGGING without the output, only statistics

This is the current implementation:

The SQL-92 statement 'SET PRO_SERVER LOG' controls logging for all connections to all OpenEdge SQL Servers.  It is executed from any ODBC or JDBC client application to set the logging on and off using the following syntax:

OpenEdge 10.1A: SET PRO_SERVER LOG [ ON | OFF ] [ WITH ( STATEMENT ) ];
OpenEdge 10.1B and later: SET PRO_SERVER LOG [ ON | OFF ][ WITH ( { STATEMENT, QUERY_PLAN } ) ];

Where ON indicates that logging is turned on, OFF indicates that logging is turned off, STATEMENT indicates that statement tracing information is written to each log file and QUERY_PLAN indicates that the query plan information is written to the log file.

This is perfect for development but not for identifying performance issues with sql clients where an stupid users queries the whole database

It would be nice to have the same without the output, only an output statistics (runtime, amount of records, ..)

Comments
  • It will great if we have a tool like Oracle tkprof producing a summarized output with runtime, records and related statistics, easing to find the bootlenecks.