| description | title | ms.custom | ms.date | ms.service | ms.reviewer | ms.suite | ms.topic |
|---|---|---|---|---|---|---|---|
Learn more about: Troubleshooting Performance Issues |
Troubleshooting Performance Issues3 |
06/08/2017 |
biztalk-server |
article |
This section contains general guidelines for diagnosing and resolving performance problems related to [!INCLUDEbtsBizTalkServerNoVersion] and its dependencies. These guidelines may also be used preemptively, to identify potential problems before they become critical issues.
Typically a performance problem can be narrowed down to one of the following components of a [!INCLUDEbtsBizTalkServerNoVersion] environment:
-
A receive adapter or the system from which the adapter is receiving documents. For example, if documents are being received by the HTTP adapter at a suboptimal rate then the problem may be with the HTTP receive adapter or with the client that is posting to the HTTP adapter.
-
An orchestration service instance.
-
Performance of the [!INCLUDEbtsSQLServerNoVersion] that hosts the [!INCLUDEbtsBizTalkServerNoVersion] databases.
-
A send adapter or the system that the adapter is sending documents to. For example, if documents are being sent by the SQL adapter at a suboptimal rate then the problem may be with the SQL send adapter or with the computer running [!INCLUDEbtsSQLServerNoVersion] that the SQL adapter is updating.
Use the following guidelines to help identify the components of the [!INCLUDEbtsBizTalkServerNoVersion] environment that are performing poorly:
-
Capture any warnings or errors generated in the [!INCLUDEbtsBizTalkServerNoVersion] or [!INCLUDEbtsSQLServerNoVersion] Event Viewer.
-
Follow the steps in "Identifying Performance Bottlenecks" in [!INCLUDEbtsBizTalkServerNoVersion] Help at https://go.microsoft.com/fwlink/?LinkId=154238 to help identify performance bottlenecks.
Once the poorly performing component has been identified, follow the appropriate guidelines to help resolve the issue:
Guidelines for resolving performance problems related to send and receive adapters
-
For information about troubleshooting problems with [!INCLUDEbtsBizTalkServerNoVersion] adapters, see "Troubleshooting BizTalk Server Adapters" in [!INCLUDEbtsBizTalkServerNoVersion] Help at https://go.microsoft.com/fwlink/?LinkId=154240. This section contains general troubleshooting information including information about how to set up logging for certain adapters, and information that can be used diagnose network problems, problems with MSDTC, problems with the registry, problems with the file system, and problems with IIS.
-
For information about troubleshooting problems with MSDTC, certificates, Enterprise Single Sign-On, and [!INCLUDEbtsSQLServerNoVersion], see the appropriate section of "Troubleshooting BizTalk Server Dependencies" in [!INCLUDEbtsBizTalkServerNoVersion] Help at https://go.microsoft.com/fwlink/?LinkId=154242.
Guidelines for resolving performance problems related to orchestrations
-
For information about modifying the appropriate sections of the BTSNTSvc.exe.config file, see "Orchestration Engine Configuration" in [!INCLUDEbtsBizTalkServerNoVersion] Help at https://go.microsoft.com/fwlink/?LinkId=154244.
Guidelines for resolving performance problems related to SQL Server
-
SQL Server Profiler can be used to capture Transact-SQL statements that are sent to [!INCLUDEbtsSQLServerNoVersion] and the [!INCLUDEbtsSQLServerNoVersion] result sets from these statements. Since [!INCLUDEbtsBizTalkServerNoVersion] is tightly integrated with [!INCLUDEbtsSQLServerNoVersion], the analysis of a [!INCLUDEbtsSQLServerNoVersion] Profile trace can be a useful tool for analyzing problems that may occur in [!INCLUDEbtsBizTalkServerNoVersion] when reading from and writing to [!INCLUDEbtsSQLServerNoVersion] databases. For information about how to use [!INCLUDEbtsSQLServerNoVersion] Profiler, see "Using SQL Server Profiler" in [!INCLUDEbtsSQLServerNoVersion] Books Online at https://go.microsoft.com/fwlink/?linkid=104423.
-
[!INCLUDEbtsSQLServerNoVersion] Management Studio can be used to execute SQL statements directly against [!INCLUDEbtsSQLServerNoVersion] databases. This functionality may be useful for querying the [!INCLUDEbtsBizTalkServerNoVersion] databases or for updating the [!INCLUDEbtsBizTalkServerNoVersion] databases in certain scenarios. For more information about using SQL Server Management Studio to execute SQL statements, see "Writing, Analyzing, and Editing Scripts with SQL Server Management Studio" in [!INCLUDEbtsSQLServerNoVersion] Books Online at https://go.microsoft.com/fwlink/?linkid=104425.
-
For more information about resolving performance problem related to the [!INCLUDEbtsBizTalkServerNoVersion] databases, see "Troubleshooting SQL Server" in [!INCLUDEbtsBizTalkServerNoVersion] Help at https://go.microsoft.com/fwlink/?LinkId=154250.