SQL Optimizer for SQL Server 10.1.2 - User Guide

Test for Scalability Options

This topic may not include a description for every field in the screen or dialog.

To set test for scalability options

1. Click in the main menu..

2. Select General | Test for Scalability.

3. Review the following for additional information:

   Minimum number of virtual users	Enter the minimum number of virtual users to use for scalability testing. Range: 1 to 1,000,000,000
   Maximum number of virtual users	Enter the maximum number of virtual users to use for scalability testing. Range: 1 to 1,000,000,000
   Step value of virtual users	Enter the number of virtual users to increase by for each step of scalability testing. Range: 1 to 1,000,000,000
   Distribution Model	Select a latency think time distribution model: None—Does not insert a latency think time between executions. Absolute—Uses the value entered in the Duration field as the latency think time between executions. Uniform—Uses a random duration between 1 millisecond and the value entered in the Duration field as the latency think time. Negative Exponential—Uses a random duration based on a mathematical model weighted towards lower latency think times. The value entered in the Duration field is used for calculating think times. Normal—Uses a random duration based on a mathematical model weighted towards average latency think times. The value entered in the Duration field is used for calculating think times. Poisson—Uses a random duration based on a mathematical model weighted towards discrete latency think times. The value entered in the Duration field is used for calculating think times.
   Duration (milliseconds)	Enter a duration in milliseconds. Note: How SQL Optimizer uses the value you enter depends on the distribution model selected.
   Execute Each SQL Statement by	Select one of the following: Duration (seconds)—Enter the duration of the scalability test in seconds. Number of times—Enter the number of times to execute the SQL statement. Range: 1 to 100

Note: These options apply to SQL Optimizer and SQL Scanner.

Related Topics  

Test for Scalability

Directory Setup Options

To set directory setup options

1. Click in the main menu.

2. Select General | Directory Setup.

3. Review the following for additional information:

   Use Application Data Directory	Select the checkbox to use application data as the data directory. You have three options to set the directory for the application data: Click to freely define the data directory. Click to use the application default directory. Click to use the system local default directory. Note: The change applies after you restart the application.
   Optimize SQL data directory	Select the directory to store data files created during optimization.
   Find SQL data directory	Select the directory to store data files created using Find SQL.
   SQL Scanner data directory	Select the directory to store data files created while scanning.
   Manage Plan Guides data directory	Select the directory to store data files created using Manage Plan Guides.
   Optimize Indexes data directory	Select the directory to store data files created using Optimize Indexes.
   Note: It is advisable not to change the directory location once you create data files because SQL Optimizer will not move existing files to the new directory location.

Note: These options apply to SQL Optimizer and SQL Scanner.

Database Setting Options

To set database settings

1. Click in the main menu.

2. Select General | Database Setting.

3. Review the following for additional information:

   Set ANSI_NULLS	Select whether to recognize Ansi nulls settings. You can also select the Use Database Default option to retrieve this setting from the database.
   Set QUOTED_ IDENTIFIER	Select one of the following options: Set Quoted Identifier On—Uses a delimited identifier (" ") for table names. This setting must be turned on if the space character is used in the name of tables or other database objects.  Set Quoted Identifier Off—Does not use a delimited identifier for table names. Use Database Default—Retrieves the Quoted_Identifier setting from the database.
   Set ANSI_PADDING	Select one of the following options: Set ANSI_PADDING ON—Pad original value with trailing blanks for char(n) NOT NULL columns and trailing zeros for binary(n) NOT NULL columns to the length of the column. Pad original value with trailing blanks for char(n) NULL columns and trailing zeros for binary(n) NULL columns to the length of the column. Trailing blanks for varchar(n) columns and trailing zeros in binary values inserted into varbinary(n)columns are not trimmed. Set ANSI_PADDING OFF—Pad original value with trailing blanks for char(n) NOT NULL columns and trailing zeros for binary(n) NOT NULL columns to the length of the column. Trailing blanks for char(n) NULL columns and trailing zeros for binary(n) NULL columns are trimmed. Trailing blanks for varchar(n) columns and trailing zeros in binary values inserted into varbinary(n)columns are trimmed. Use database default—Retrieves the ANSI_PADDING setting from the database.
   Set ANSI_WARNINGS	Select one of the following: Set ANSI_WARNINGS ON—Generates warning messages when conditions violate ANSI rules. Set Set ANSI_WARNINGS OFF—Does not generate warning messages. Use database default—Retrieves the ANSI_WARNINGS setting from the database.
   Set ANSI_NULL_DFLT_ON	Select one of the following: Set ANSI_NULL_DFLT_ON ON—Specifies the default value as NULL for a column, alias data type, or user-defined type. Set Set ANSI_NULL_DFLT_ON Off—Specifies the default value as NOT NULL for a column, alias data type, or user-defined type. Use database default—Retrieves the ANSI_NULL_DFLT_ON settings from the database.
   Set IMPLICIT_TRANSACTIONS	Select one of the following: Set IMPLICIT_TRANSACTIONS ON—Sets connection to implicit transaction mode. Set Set IMPLICIT_TRANSACTIONS OFF—Sets connection to auto-commit mode.
   Set CURSOR_CLOSE_ON_COMMIT	Select one of the following: Set CURSOR_CLOSE_ON_COMMIT ON—Closes any open cursors on a commit or rollback of a transactions. Set CURSOR_CLOSE_ON_COMMIT OFF—Does not close cursors on a commit. Closes any cursors on a rollback except those defined as INSENSITIVE or STATIC. Use database default—Retrieves the CURSOR_CLOSE_ON_COMMIT from the database.
   Note: These options should correspond to your SQL Server settings.

Note: These options apply to SQL Optimizer and SQL Scanner.

Appearance

To set directory setup options

1. Click in the main menu.

2. Select General | Appearance.

3. Review the following for additional information:

   SQL Text Editor	Select the font settings for the SQL Text Editor.
   Other Data	Select the font settings for other data.
   Size	Select the font size.

Note: These options apply to SQL Optimizer and SQL Scanner.