Use the Application Profiling Wizard to identify and fix table fragmentation. You should periodically check for fragmentation on your production database.
This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Diagnosing table fragmentation.
This tutorial assumes that you have created the test database, app_profiling.db. See Tutorial: Creating a test database for the application profiling tutorials.
Start Sybase Central. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.
In Sybase Central, connect to app_profiling.db as follows:
Click Connections » Connect With SQL Anywhere 16.
In the Connect window, complete the following fields to connect to the test database, app_profiling.db:
In the User ID field, type DBA.
In the Password field, type sql.
In the Action dropdown list, select Start and connect to a database on this computer.
In the Database file field, type C:\AppProfilingTutorial\app_profiling.db.
In the Start Line field, type dbeng16 -x tcpip.
In Sybase Central, click Mode » Application Profiling.
If the Application Profiling Wizard does not appear, click Application Profiling » Open Application Profiling Wizard.
Start the Application Profiling Wizard as follows:
On the Profiling Options page, click Overall database performance based on the database schema.
On the Analysis File page, in the Save the analysis to the following file field, type C:\AppProfilingTutorial\analysis. If you are prompted to replace the file because it already exists, click Yes.
A list of recommendations appears in the Application Profiling Details pane.
If you see Fragmented Tables, double-click it. A Recommendation window appears containing a SQL statement that you can run to resolve the table fragmentation.
Close Sybase Central.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|