BizTalk 2006 R2 & SQL Server Shared Memory Protocol

Categories: BizTalk Posted by TK on 3/13/2009 5:09 PM | Comments (2)

Page copy protected against web site content infringement by Copyscape

If you are using a single computer configuration for BizTalk 2006 R2 and if you are experiencing performance degradation, there is a simple setting that you can try before spending too much time attacking performance issues.

Disable SQL Server Shared Memory Protocol

1.    In SQL Server Configuration Manager, expand SQL Server 2005 Network Configuration, and select Protocols for MSSQLSERVER.
2.    Right-click Shared Memory, and then click Disable.
3.    Close and Re-cycle SQL Server.

If you are using SQL 2000, disable Shared Memory using SQL Server Client Network Utility.

Again, this issue may not occur on a multi-computer configuration (database server is different from the BizTalk Sever).

Comments

Roxana
Roxana New Zealand on 12/8/2009 2:46 AM Hi there,

I am trying to install Biztalk 2009. In the doco it recomends to disable the Shared memory protocol. The only pb is that it is the only enabled protocol. If I disable this which other one should I enable?!!!
Sorry if this is very silly question...

Thanks,
Rox
TK
TK United States on 12/8/2009 5:19 PM Hi Roxana,
Check with your IT team on your SQL Server protocols. You should be able to enable TCP/IP or named pipes based on your enterprise policy. To enable/disable protocols, navigate to SQL Server Configuration Manager -- SQL Server 2005 Network configuration.

Add comment


(Will show your Gravatar icon)

  Country flag

biuquote
  • Comment
  • Preview
Loading