Post-configuration steps to optimize your environment
Post-configuration steps to help improve performance, maintain your BizTalk environment, and install the EDI schemas.
Disable Shared Memory protocol in SQL Server
- Open SQL Server Configuration Manager.
- Expand SQL Server Network Configuration, and select Protocols for MSSQLSERVER.
- Right-click Shared Memory, and select Disable.
- Select SQL Server Services, right-click SQL Server (MSSQLServer), and select Restart.
- Close SQL Server Configuration Manager.
Configure the SQL Agent jobs
- SQL Server Management Studio, and connect to Database Engine.
Expand SQL Server Agent, and expand Jobs. Configure the following jobs:
Job Name Description Why you need it Backup BizTalk Server Backs up the BizTalk Server databases and the log files. When configuring the job, you determine parameters like frequency and file location.
The following links describe the SQL Agent job and its parameters:
Backing Up and Restoring BizTalk Server Databases
How to Configure the Backup BizTalk Server Job
This SQL Agent job also truncates the transaction logs, which helps improve performance.
This job does not remove or delete backup files, including older files. To delete backup files, refer to The "Backup BizTalk Server" job fails when backup files accumulate over time in the Microsoft BizTalk Server database server.
DTA Purge and Archive Truncates and archives the BizTalk Server Tracking database (BizTalkDTADb). When configuring the job, you determine parameters like how many days to keep completed instances and how many to days to keep all data.
The following links describe the SQL Agent job and its parameters:
Archiving and Purging the BizTalk Tracking Database
How to Configure the DTA Purge and Archive Job
This SQL Agent job directly impacts performance by maintaining the Tracking host and purging tracking events.
Maintain your backup files
BizTalk Server does not include any job to delete backup files. As a result, how you maintain your backup files is up to you. Many users create the sp_DeleteBackupHistoryAndFiles stored procedure, and then call this stored procedure directly in the Backup BizTalk Server job. Some users create a maintenance plan. The choice is yours. This topic lists both options.
Option 1: Create the sp_DeleteBackupHistoryAndFiles stored procedure
- In SQL Server Management Studio, select the BizTalk Management database (BizTalkMgmtDb).
Select New Query, and run the following T-SQL script to create the sp_DeleteBackupHistoryAndFiles stored procedure:
CREATE PROCEDURE [dbo].[sp_DeleteBackupHistoryAndFiles] @DaysToKeep smallint = null AS BEGIN set nocount on IF @DaysToKeep IS NULL OR @DaysToKeep <= 1 RETURN /* Only delete full sets If a set spans a day in such a way that some items fall into the deleted group and the other does not, do not delete the set */ DECLARE DeleteBackupFiles CURSOR FOR SELECT 'del "' + [BackupFileLocation] + '\' + [BackupFileName] + '"' FROM [adm_BackupHistory] WHERE datediff( dd, [BackupDateTime], getdate() ) >= @DaysToKeep AND [BackupSetId] NOT IN ( SELECT [BackupSetId] FROM [dbo].[adm_BackupHistory] [h2] WHERE [h2].[BackupSetId] = [BackupSetId] AND datediff( dd, [h2].[BackupDateTime], getdate() ) < @DaysToKeep ) DECLARE @cmd varchar(400) OPEN DeleteBackupFiles FETCH NEXT FROM DeleteBackupFiles INTO @cmd WHILE (@@fetch_status <> -1) BEGIN IF (@@fetch_status <> -2) BEGIN EXEC master.dbo.xp_cmdshell @cmd, NO_OUTPUT delete from [adm_BackupHistory] WHERE CURRENT OF DeleteBackupFiles print @cmd END FETCH NEXT FROM DeleteBackupFiles INTO @cmd END CLOSE DeleteBackupFiles DEALLOCATE DeleteBackupFiles END GO
Open the Backup BizTalk Server job, and select Steps.
- Edit the Clear Backup History step so that it calls the new sp_DeleteBackupHistoryAndFiles stored procedure instead of the previous sp_DeleteBackupHistory stored procedure.
- Select OK to save your changes.
Option 2: Create a maintenance plan
- In SQL Server Management Studio, expand Management, right-click Maintenance Plans, and select Maintenance Plan Wizard.
- Name the plan (for example, name it Purge Backup Files), and then select the Change button next to Schedule.
- Choose how frequently you want to purge the backup files. These settings are completely up to you. Select OK, and then select Next.
- Select Maintenance Cleanup Task, and select Next.
- In the Cleanup Task window, go to Search folder and delete files..., select your backup Folder (maybe f:\BizTalkBackUps), and enter .bak for the File extension. You can also choose to delete files based on their age. For example, enter 3 if you want to delete files that are older than 3 weeks. Select Next.
- Finish going through the wizard and enter any additional information you want. Select Finish.
Install EDI schemas and more EDI AS2 configuration
The EANCOM, EDIFACT, HIPAA, and X12 schema files are included in a self-extracting executable file named MicrosoftEdiXSDTemplates.exe. To create EDI solutions, extract these files, and deploy with your projects. To install and extract these files:
Run the BizTalk Server installation, and install the Developer Tools and SDK component. This component downloads the MicrosoftEdiXSDTemplates.exe EDI schema file to the \XSD_Schema\EDI folder.
If you upgrade BizTalk Server, the MicrosoftEdiXSDTemplates.exe file in your installation is replaced with the new MicrosoftEdiXSDTemplates.exe file associated with the upgrade. If you need the previous the schemas, then back up the previous MicrosoftEdiXSDTemplates.exe file.
If you upgrade message schemas when you upgrade BizTalk Server to a later build, you may encounter issues using the updated schemas, or you may have to perform additional updating steps. See the "Considerations for updating schemas" section in Important Considerations for Updating Applications
Go to \Program Files\Microsoft BizTalk Server\XSD_Schema\EDI, and double-click MicrosoftEdiXSDTemplates.exe.
Extract the schemas to \Program Files\Microsoft BizTalk Server\XSD_Schema\EDI. When you extract the schemas, they are stored in EANCOM, EDIFACT, HIPAA, and X12 folders.
Add a reference to the BizTalk Server EDI application
EDI schemas, pipelines, and orchestrations are deployed in the BizTalk EDI Application. To use any other application as an EDI application, add a reference to the BizTalk EDI Application. Steps:
In the BizTalk Server Administration Console, expand Applications. Right-click the application that you want to use for EDI (such as BizTalk Application 1), select Add, and then select References.
Select BizTalk EDI Application, and select OK to save your changes.
To see references to other applications, right-click any application, and select Properties. Select References. You can also add new references, and remove existing references.
Do not add custom artifacts to the BizTalk EDI Application. It's best to leave this application as-is.
Start batch orchestrations
If you enable a party to receive and/or send EDI batches, then start the batching orchestrations. These orchestrations are not started by the installation wizard or the configuration wizard. Steps:
In BizTalk Server Administration Console, expand BizTalk EDI Application, and selectOrchestrations.
Right-click each of the following orchestrations, and select Start:
Microsoft.BizTalk.Edi.BatchSuspendOrchestration.BatchElementSuspendService (assembly: Microsoft.BizTalk.Edi.BatchingOrchestration.dll)
Microsoft.BizTalk.Edi.BatchingOrchestration.BatchingService (assembly: Microsoft.BizTalk.Edi.BatchingOrchestration.dll)
Microsoft.BizTalk.Edi.RoutingOrchestration.BatchRoutingService (assembly: Microsoft.BizTalk.Edi.RoutingOrchestration.dll)
The EDI batching orchestrations should only be started if you receive and/or send EDI batches. Starting them when the system is not receiving or sending EDI batches could affect system performance.
Migrate EDI artifacts from a previous BizTalk version
The way trading partners are managed in BizTalk Server was updated in BizTalk Server 2010 and newer versions. In the previous BizTalk Server versions, a party was created only for the trading partner, and not for the partner hosting BizTalk Server. In BizTalk Server 2010 and newer, a party must be created for all the trading partners, including the partner hosting BizTalk Server. In previous BizTalk Server versions, the encoding (X12 and EDIFACT) and transport (AS2) protocol properties are defined at the party level. In BizTalk Server 2010 and newer versions, these properties are defined through agreements.
To migrate party data from previous versions, BizTalk Server includes a Party Migration Tool. Consider the following migration paths:
|BizTalk Server Version||Migration Path|
|BizTalk Server 2006 R2||Upgrade to BizTalk Server 2009. Then, use the Party Migration Tool included with BizTalk Server 2013/2013 R2 to migrate to BizTalk Server 2013/2013 R2.
Or, use the Party Migration Tool included with BizTalk Server 2013/2013 R2 to migrate to BizTalk Server 2010. Then, upgrade to BizTalk Server 2013/2013 R2.
|BizTalk Server 2009||Use the Party Migration Tool included with BizTalk Server 2013/2013 R2 to migrate directly to BizTalk Server 2013/2013 R2.|
|BizTalk Server 2010||Upgrade to BizTalk Server 2013/2013 R2.|
The Party Migration Tool is available on the BizTalk Server media under the \PartyMigrationTool folder.
Install BizTalk Health Monitor (BHM)
BizTalk Health Monitor provides a dashboard to create and view MessageBox Viewer reports, create custom queries, run Terminator tasks, monitor multiple BizTalk environments, and more. If you are responsible for a BizTalk envrionment, we suggest you install and use this tool to check the health of your BizTalk environment, and also maintain it.
Create your hosts and host instances
It is recommended to separate some key tasks into separate hosts. For example, always create a separate host that is dedicated to only tracking. Create another host/host instance that focuses on receiving messages, another host/host instance for sending messages, and another host/host instance for orchestration.
There are many recommendations in this area. Here are a few to get you started:
Managing BizTalk Hosts and Host Instances
Providing High Availability for BizTalk Hosts
Best Practices: Create and Configure BizTalk Server Host and Host
Running Orchestrations in Multiple Hosts on the Same Computer
PowerShell to Create and Configure BizTalk Server Host, Host Instances and Handlers
BizTalk Server Resources on the TechNet Wiki