You experience slow performance after you run the OrdersGenerator.vbs sample script in the BizTalk Adapter for SQL Server Tutorial (812476)

SYMPTOMS

When you set up Usage Scenario 1 for the Microsoft BizTalk Adapter for SQL Server Tutorial, this sample creates a Port Suppliers messaging port. This messaging port specifies a file transport that references a folder.

When you run the associated OrdersGenerator.vbs script, this folder may become filled with sample messages. Over time, this behavior may slow the performance of Microsoft BizTalk Server significantly.

CAUSE

The BizTalk Adapter for SQL Server installs a tutorial that contains a sample script that is named OrdersGenerator.vbs. This sample script is located in the Microsoft BizTalk Adapter for SQL Server\Samples\Tutorial\ folder.

When you run the OrdersGenerator.vbs script, the script creates objects in the BizTalk Messaging Manager to illustrate how to use the adapter. The settings for this sample run a query against a SQL database, and then write the results to the referenced folder as a separate file every 1 second.

If you run OrdersGenerator.vbs, and then you do not disable the job that is located in the adapter Microsoft Management Console (MMC), the folder will become filled with files that are written at a rate of one per second.

WORKAROUND

To stop the created job, open the adapter administration MMC, right-click the job, and then click Stop. To disable the job, right-click the job, and then click Job Enable to clear the check mark from the menu.