Database Properties window: Profiling Settings tab

This window has the following components:

  • Capture and view profiling information in this database for   Select this option if you want SQL Anywhere to monitor the execution times of stored procedures, functions, events, and triggers. You can use database profiling information to determine which procedures can be fine-tuned to increase performance within your database. Profiling information appears on the Profile tab in Sybase Central.

    Selecting this option activates the following options:

    • All connections   Select this option to enable profiling on all connections.

    • Connections with the following user ID   Select this option and choose a user ID from the dropdown list to specify a particular user ID to capture profiling information for.

    • Clear Now   Select this option to delete all the collected profiling data for the database and turn off profiling for the database. This button is only enabled when profiling is turned on for the database.

  • View profiling information from the following profiling log file   Select this option to view profiling information from a log file. Specify the name and location of the profiling log file (a file with an extension of .plg) or click Browse and navigate to the file. This option is only enabled when profiling is turned off for the database.

  • Use the profiling information in the following profiling log file as a baseline for comparison   Select this option to specify a second profiling log file to use as a baseline for comparison to profiling information being collected, or to the profiling log file selected in the previous option. This option is only enabled if Capture and View Profiling Information in This Database For or View Profiling Information From the Following Profiling Log File is selected.

  • Save the profiling information currently in the database to the following profiling log file   Select this option to save the current profiling information in the database to a profiling log file. Specify the file name and location, with an extension of .plg or click Browse and navigate to the file.

  • Reset Now   Deletes all the collected profiling data for the database. If profiling is turned on, the database immediately starts collecting new profiling information about procedures, functions, events, and triggers.

 See also