Use the following procedure to create the test database app_profiling.db using data from the sample database. The test database is used in all application profiling tutorials.
Create the directory C:\AppProfilingTutorial.
Open a command prompt and type the following command to create the test database app_profiling.db. The samples-dir is the location of your Samples directory:
dbunload -c "UID=DBA;PWD=sql;DBF=samples-dir\demo.db" -an C:\AppProfilingTutorial\app_profiling.db
For example, on a computer with Windows XP and SQL Anywhere installed in the default locations, the command would be:
dbunload -c "UID=DBA;PWD=sql;DBF=C:\Documents and Settings\All Users\Documents\SQL Anywhere 11\Samples\demo.db" -an C:\AppProfilingTutorial\app_profiling.db
For more information about the location of samples-dir, see Samples directory.
In the application profiling tutorials, tracing information is stored in the same database that you are profiling (app_profiling.db). However, if you profile a database that experiences heavy loads, you should consider storing tracing data in a separate database to avoid impacting performance on the production database.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|