[progress Communities] [progress Openedge Abl] Sql Server Logging Without The Output, Only...

  • Thread starter Thread starter Stefan Marquardt
  • Start date Start date
Status
Not open for further replies.
S

Stefan Marquardt

Guest
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, ..)

Continue reading...
 
Status
Not open for further replies.
Back
Top