Enables request logging of operations.
{ dbsrv10 | dbeng10 } -zr { SQL | HOSTVARS | PLAN | PROCEDURES | TRIGGERS | OTHER | BLOCKS | REPLACE | ALL | YES | NONE | NO } ...
All operating systems and servers.
This should only be used when tracking problems. The information appears in the Server Messages window or is sent to the logging file.
The values for -zr return the following types of information:
SQL enables logging of the following:
PLAN enables logging of query plans (short form). Query plans for procedures are also recorded if logging of procedures (PROCEDURES) is enabled.
HOSTVARS enables logging of host variable values. If you specify HOSTVARS, the information listed for SQL is also logged.
PROCEDURES enables logging of statements executed from within procedures.
TRIGGERS enables logging of statements executed from within triggers.
OTHER enables logging of additional request types not included by SQL, such as FETCH and PREFETCH. However, if you specify OTHER but do not specify SQL, it is the equivalent of specifying SQL+OTHER. Including OTHER can cause the log file to grow rapidly and could negatively impact server performance.
BLOCKS enables logging of details showing when a connection is blocked and unblocked on another connection.
REPLACE at the start of logging, the existing request log is replaced with a new (empty) one of the same name. Otherwise, the existing request log is opened and new entries are appended to the end of the file.
ALL logs all supported information. This is equivalent to specifying SQL+PLAN+HOSTVARS+PROCEDURES+TRIGGERS+OTHER+BLOCKS. This setting can cause the log file to grow rapidly and could negatively impact server performance.
NO or NONE turns off logging to the request log.
Once the database server is started, you can change the request log settings to log more or less information using the sa_server_option system procedure. See sa_server_option system procedure.
You can find the current value of the RequestLogging setting using the following query:
SELECT PROPERTY( 'RequestLogging' )
RequestLogMaxSize The maximum size of the file used to record request logging information, in bytes. If you 0, then there is no maximum size for the request logging file, and the file is never renamed. This is the default value.
When the request log file reaches the size specified by either the sa_server_option system procedure or the -zs server option, the file is renamed with the extension .old appended (replacing an existing file with the same name if one exists). The request log file is then restarted. See -zs server option.
RequestLogNumFiles The number of request log file copies to retain.
If request logging is enabled over a long period of time, the request log file can become large. The -zn option allows you to specify the number of request log file copies to retain. See -zn server option.
RequestTiming Instructs the database server to maintain timing information for each request. This feature is turned off by default. You can use the sa_performance_diagnostics procedure to obtain a summary of the request timing information. See -zt server option, and sa_performance_diagnostics system procedure.
SecureFeatures Specifies features that are disabled for databases running on this database server. The feature-list is a comma-separated list of feature names or feature sets. For a list of valid feature-list values, see -sf server option.