Recently I was experiencing ever-increasing build & deployment times on a development machine for a simple BizTalk 2010 solution. The Windows 7 VM had 8GB RAM, so that wasn’t the issue. Yet a single application deployment was taking up to ten minutes!
After much searching, I finally came upon this post by Ricardo Bessa, which thankfully pointed me in the right direction.
Bottom line is paying attention to the BizTalk installation doco by disabling the SQL Server Shared Memory Protocol on a single-computer BizTalk installation (which is typically our development configuration).
To disable Shared Memory protocol for SQL Server
Click Start, point to All Programs, point to Microsoft SQL Server 2008 R2, 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.
Hope this helps someone!