In Sybase Central, you can use predefined views to review and analyze data in the profiling database.
You must have run at least one profiling session.
You must know the name and location of the profiling database. To determine this information, go to the General page of the Options window.
Context and remarks
This task assumes you are using the default profiling database.
You can also use Interactive SQL to work with Profiler views.
Use the SQL Anywhere 16 plug-in to connect to the profiling database, using the following options:
User ID Type mlprofiler for the User ID.
Password Type sql for the password.
Action Choose Start and connect to a database on this computer.
Database file Enter the path information for the profiling database or click Browse to select the file. The default database file is mlprofiler.db in a folder called MLProfiler16 in your Documents folder.
Server name Type MLProfilerDB.
Start line To set the initial memory for caching database pages and other database server information, type the following:
dbeng16.exe -c 1g
Expand the mlprofiler database and double-click Views to see a list of the MobiLink Profiler views.
Select a view. The following views are available:
The SQL pane on the right includes a comment at the top that describes the selected view.
The server-related sampling data is for metrics that are also available in the SQL Anywhere Monitor for MobiLink.
The following sample query shows the event scripts that consumed the most time for all synchronizations in the second session:
select * from event_total_times where session_id = 2 order by 1 desc
The following sample query shows the fastest synchronization completion rates for all the sessions:
select max( "Successful syncs/s" ) as "Max syncs/s", session_id from server_throughput_samples group by session_id order by 1 desc, 2
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|