Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Performance monitoring and diagnostic tools » Use other diagnostic tools and techniques » Procedure profiling using system procedures

 

Filtering procedure profiling by user (SQL)

If necessary, you can see what procedures a specific user is using, without preventing other connections from using the database. This is useful if the connection already exists, or if multiple users connect with the same user ID.

Prerequisites

DBA or PROFILE authority.

Context and remarks

Many.

 Filter procedure profiling by user

  1. Connect to the database.

  2. Call the sa_server_option system procedure as follows:

    CALL sa_server_option( 'ProfileFilterUser' , 'userid' );

Results

The value of userid is that of the user being monitored.

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1