Under certain stress conditions (such as clients accessing SQL Server from the same computer), the SQL Server Shared Memory protocol may lower BizTalk Server performance. You can resolve this problem by disabling the use of the Shared Memory network protocol in the SQL Server Client Network Utility.
To disable Shared Memory protocol for SQL Server:
- Click Start, point to All Programs, click your version of SQL Server, click Configuration Tools, and then click SQL Server Configuration Manager.
- In SQL Server Configuration Manager, expand SQL Server Network Configuration, and then click Protocols for MSSQLSERVER.
- Right-click Shared Memory, and then click Disable.
- Click SQL Server Services, right-click SQL Server (MSSQLSERVER), and then click Stop. After the service has stopped, right-click SQL Server (MSSQLSERVER) again, and then click Start.
- Close SQL Server Configuration Manager.