This tutorial assumes you have created the test database required for the application profiling tutorials. If you have not, see Create a test database for the application profiling tutorials.
Connect to app_profiling.db as follows:
In Sybase Central, in the SQL Anywhere 12 plug-in, choose Connections » Connect With the SQL Anywhere 12.
In the Connect window, complete the following fields to connect to the test database, app_profiling.db, and then click Connect:
Authentication Database
User ID DBA
Password sql
Action Start A Database On This Computer
Database File C:\AppProfilingTutorial\app_profiling.db
Start Line dbeng12 -x tcpip
In the left pane, click app_profiling - DBA, and then choose File » Open Interactive SQL.
Interactive SQL starts and connects to the app_profiling.db database.
In Interactive SQL, run the following SQL statements:
Create a table:
CREATE TABLE table1 ( Count INT ); |
Create a baseline procedure:
CREATE PROCEDURE baseline( ) BEGIN INSERT table1 SELECT COUNT (*) FROM rowgenerator r1, rowgenerator r2, rowgenerator r3 WHERE r3.row_num < 5; END; |
Commit the changes you made to the database:
COMMIT; |
Close Interactive SQL.
Click this link to continue the tutorial: Lesson 2: Run an updated procedure against the baseline procedure.
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |