|
 Client/Server
Software Benelux
Tel: +31 23 542 22 27
Embarcadero SQL Profiler
Identify and Isolate Performance Problems
 Embarcadero
SQL Profiler is an optional add-on module that allows Oracle DBAs
and Developers to quickly and easily identify poorly running code
within their databases. A rich, “working” graphical interface
provides the backdrop for users to pinpoint and tune the most expensive
code in their applications. Once captured, profiling session data
is stored so sessions can be historically compared to determine
the effectiveness of incremental code tuning.
From within the familiar DBArtisan or Rapid SQL console, Embarcadero
SQL Profiler lets users start, stop, and analyze profiling sessions
with simple point-and-click ease. To accommodate users who want
to capture profiling sessions for long-running code objects, the
graphical displays can be set to show in milliseconds, seconds,
and even minutes.
Embarcadero SQL Profiler is available as a licensed add-on within
DBArtisan and Rapid SQL.
Profiling Data Capture
Embarcadero SQL Profiler is equipped with functionality that makes
data capture easy, including:
- Start, which begins a new profiling session or opens
a previous profiling session.
- Flush, which moves data from dynamic tables into analysis
tables for reference.
- Run Summary, which enables you to view the date and total
time for each profile.
- Run Detail, which enables you to view the code object’s
owner, object type, and execution times for each code object captured
by the profiling session.
- Clear Profile Table, which deletes data from your profile
tables.
- Stop, which pauses the data gathering operation.
- Stop & Analyze, which populates the summary tables
to view the Unit Detail and Run Summary windows.
Multiple Profile Views
With Embarcadero SQL Profiler, programmers can view the information
for all runs of the object, or filter profile information based
on the unit type or unit owner. Capabilities include:
- Unit Summary, which enables you to run time statistics
for each code object captured in a profiling session.
- Unit Detail, which enables you to drill into a profiling
session and view the length of time it took each line of source
code to execute.
Advanced View Offers More Detail
The Advanced View of Embarcadero SQL Profiler Unit Detail window
contains the following information for each profile:
- Hit Lines
- Missed Lines
- Line Number
- Calls
- Percentage of the Total Time
- Average Time
- Minimum Time
- Maximum Time
- Total Time
DBMS Support
Embarcadero SQL Profiler supports the following DBMS versions running
on UNIX®, Linux, and Windows®-based servers:
System Requirements
- Windows 98, NT, 2000, or XP
- 64 MB memory
- 42 MB disk space
Home
--> Products -->
Ensure --> SQL Profiler
|
|
