You can view profiling results for stored procedures, user-defined functions, triggers, system triggers, and events in your database.
Prerequisites
DBA authority.
Context and remarks
Many.
Use the SQL Anywhere 12 plug-in to connect to the database.
Enable procedure profiling.
In the left pane, double-click one of the following: Triggers, System Triggers, Procedures & Functions, or Events.
In the right pane, click the Profiling Results tab.
A list appears of all the objects of the selected type that have executed since you enabled procedure profiling.
An expected object might be missing because it has not been executed. Or, it may have executed but the results have not yet been refreshed. Press F5 to refresh the list.
If you find more objects listed than you expected, one object can call other objects, so there may be more items listed than those that users explicitly called.
To view in-depth profiling results for a specific object, double-click the object on the Profiling Results tab.
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |