Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Application profiling tutorials » Tutorial: Diagnosing deadlocks


Lesson 1: Creating the test database

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.

To create the test database
  1. Create the directory C:\AppProfilingTutorial.

  2. 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.

See also