Using the Performance Tuning Wizard

The Performance Tuning Wizard leads you step-by-step through a series of questions about your application. Based on your answers, the Performance Tuning Wizard provides the optimal settings for performance-related connection properties.

You can use the Performance Wizard to create a connection string for a standard ADO.NET application or an Entity Framework application, and tune the data providers for use with applications that use Data Access Application Blocks.

Note: For an ADO.NET Entity Framework data provider, you can use the values generated by the Performance Tuning Wizard when you specify the options for a new connection in the Entity Data Model Wizard.

The Performance Tuning Wizard is available as a component in Visual Studio.

Starting the Wizard

To start the Wizard from the Visual Studio menu bar:

1. Select Tools.
2. Select Progress DataDirect / Run Progress DataDirect Performance Tuning Wizard....

To start the Wizard from a connection in the Visual Studio Server Explorer:

1. Right-click the connection.
2. Select Run Progress DataDirect Performance Tuning Wizard....

Tuning Performance Using the Wizard

When you launch the Performance Tuning Wizard from Visual Studio, you can:

• Generate the values for connection string options that are related to performance. These values can be copied into a connection string.
• Modify an existing connection.
• Generate a new application pre-configured with a connection string optimized for your environment. The Performance Tuning Wizard provides options to select the type of application and the version of ADO.NET code that you want to use.

To use the Performance Tuning Wizard in Visual Studio:

1. Do one of the following steps to start the Performance Tuning Wizard:

   • To create a new connection, select Tools / Progress DataDirect / Run Progress DataDirect Performance Tuning Wizard.... When the Performance Tuning Wizard Welcome dialog appears, click Next. Continue at Step 2.
   • To modify an existing connection, in Server Explorer, right-click a data connection, and then select Run Progress DataDirect Performance Tuning Wizard.... When the Performance Tuning Wizard Welcome dialog appears, click Next. Continue at Step 3.

2. Select the DataDirect data provider that you want to use, and click Next.

3. The Wizard presents a series of questions about your environment. Click Next to proceed through the Wizard.

   The following figure shows an example of one of the questions you may be asked to answer for a DataDirect Connect for ADO.NET data provider.

   

4. When you have answered all questions for a data provider, the Result dialog appears, and a connection string is displayed.

   Select one of the following actions:

   • To make the connection string available to other applications (the initial default), select Copy the connection string to clipboard. You can use the connection string in other applications.

   • To create a new connection, select Create a new connection with the Performance Tuning Wizard connection string options.

     The Modify Connection dialog box appears, allowing you to specify a host, password, user ID, and other information. See Creating a New Project for more information.

   • If you launched the Performance Tuning Wizard from an existing connection, select Re-configure the connection with the additional Performance Tuning Wizard connection string options. A connection dialog box might be presented so that you can enter the password.

     

   • To create a new ADO.NET application, select Generate a new application pre-configured with these connection settings. In this example, the Performance Tuning Wizard was run on an Oracle connection, so an Oracle application is generated, using the DataDirect Oracle Project template. See Using Provider-specific Templates for more information about the provider-specific templates.

     Define additional information for the new application:

   • Select Using data provider-specific interfaces to create an application that uses DataDirect data provider-specific features.

   • Select Using common programming interfaces to create an application that uses the ADO.NET common programming model.

   • Type the location for the project, or, click Browse... to select the location.

   • Select the project type. By default, the Wizard creates a C# application.

5. Click Finish to exit the Performance Tuning Wizard.

   If you created a new application, it is displayed in the Solution Explorer.

   

If you are using Visual Studio to add a data connection, you can manually add the values from the connection string into the Advanced Properties window. See Creating a New Connection in Server Explorer for more information.

See Connection String Option Descriptions for detailed information about supported connection string options for each data provider:

• DB2 Data Provider Connection String Options contains information for the DB2 data provider and DB2 Entity Framework data provider.
• Oracle Data Provider Connection String Options contains information for the Oracle data provider and Oracle Entity Framework data provider.
• SQL Server Data Provider Connection String Options contains information for the Microsoft SQL Server data provider.
• Sybase Data Provider Connection String Options contains information for the Sybase data provider and Sybase Entity Framework data provider.