BizTalk: Slow Performance while viewing or restarting host instances
Recently, while troubleshooting performance issues at a client, I came across a peculiar issue. The environment in question was a multi- server environment with multiple BizTalk Servers (2010) connected to a SQL Server cluster. The issue was extremely slow performance when trying to view, refresh, start or stop the host instances through the Administration Console. Now usually it takes a few seconds for host instances to start, stop, or restart, however, in this case just refreshing the status of the host instances was taking over a minute.
The problem was that one of the BizTalk Servers in the group was offline for some time, causing the host instances tied to that BizTalk Server, within the same group, to become unresponsive. This caused slowdown in viewing the host instances for any of the other servers in the BizTalk Group.
There are two ways to resolve this:
1. Turn on any offline BizTalk Servers
2. Remove the host instances for any BizTalk Servers that are no longer needed.
In our case, the second option was our chosen on, as the offline BizTalk server was no longer needed. Once we removed the host instances from the group, the Administration Console was a lot snappier and responded quicker when refreshing, starting, or stopping host instances.