Use this procedure to identify table fragmentation and how to locate table fragmentation warnings. It is recommended that you periodically check for fragmentation warnings on your production database.
The statements you executed in the previous procedure introduced table fragmentation. However, on some systems there might not be enough table fragmentation to result in the warnings and recommendations described in this procedure.
In Sybase Central, choose Mode » Application Profiling.
If the Application Profiling Wizard does not appear, choose Application Profiling » Open Application Profiling Wizard.
On the Profiling Options page, select Overall Database Performance Based On The Database Schema.
On the Analysis File page, save the analysis file in the appropriate directory. For example, C:\AppProfilingTutorial.
Click Finish.
A list of recommendations appear in the Application Profiling Details pane.
To view more detail, double-click Fragmented Tables. A Recommendation window appears containing a SQL statement you can run to resolve the table fragmentation.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |