Defining a Workload Using Statement Text
SQL statements can be typed in or selected from one or more files. All text specified up to a semi-colon followed by a new line without any additional text is considered a single request. After the workload is defined, the execution plans are captured in the specified QCD.
To define a workload using an SQL statement
You can set the sample size for collecting statistics on the tables prior to creating a workload. The statistics are collected into the QCD while capturing the execution plans for the workload statements. Go to Tools > Options > Preferences, and select the General tab.
1 Select Workload > Create > Using Statement Text.
The Define Workload using Statements dialog box opens.
2 Set the criteria for defining the workload by filling in the dialog box.
The following table describes the fields and buttons in this dialog box.
|
Field/Button |
Description |
|
SQL Statements |
|
|
SQL Statement |
Type the SQL statement to be analyzed or select a file by clicking Browse. |
|
Frequency |
Specifies the number of times the statement gets executed in the workload. The default value is 1. |
|
Add |
Adds the SQL statement written in the SQL Statement box to the workload. |
|
Browse |
Browses the file which contains the SQL statements. |
|
Selected Statements |
|
|
QCD Name |
Specifies the QCD on which the captured workload is created. Click |
|
Workload Name |
Creates a name for the workload to be created. |
|
Frequency |
Displays the frequency of each SQL statement that has been added. |
|
Statement Text |
Displays the text of the SQL statement. |
|
Remove |
Removes the selected SQL statements. |
|
Replace |
Replaces the selected statement with the statement in the edit box. |
to search existing QCDs.3 Click OK to start the workload definition process.
Note: If the QCD name you previously entered does not exist, a message appears asking if you want to create the QCD. Click Yes to create the QCD, or click No to select an existing QCD.
When the process is complete, the Workload Definition Summary window opens.
If errors occur while creating a workload, see “Errors While Defining a Workload” on page 62.
4 Check the workload, and click OK.
The workload is now in the workload cache and is ready to be analyzed. For more information, see “Chapter 6 Analysis” on page 81