Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

Enabling procedure profiling

Once procedure profiling is enabled, the database server gathers profiling information until you disable profiling or until the database server is shut down.

To enable procedure profiling

1. Connect to your database as the DBA.

2. Choose Mode > Application Profiling.

   • If the Application Profiling wizard appears, follow the wizard instructions.

   • If the wizard does not appear, choose Application Profiling > Open Application Profiling wizard, and then follow the wizard instructions.

3. On the Profiling Options page of the Application Profiling wizard, select Stored Procedure, Function, Trigger or Event Execution Time. Do not select any of the other options.

4. Select Finish.

   The database server begins procedure profiling. If you attempt to switch to another mode, the database server asks whether you want to continue procedure profiling. Select No to continue working in other modes while profiling continues.

• Resetting procedure profiling
• Disabling procedure profiling
• Analyzing procedure profiling results