Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  BizTalk is overwhelming target server...

Author  Topic  MuadDBA 628 Posts Posted - 2009-07-08 : 16:59:11 Hi guys, I have an issue where a biztalk process communicates with my SQL server to update data. Unfortunately, they don't seem to be able to throttle it back by the number of connections, and it opens up to 300 connections to my SQL Server at one time. This, combined with the server's regular dutires, is more than it can handle. Is anyone familiar enough with Biztalk to tell me hw to tell my BizTalk admins how to limit the number of connections it opens to its target? Setting the number of threads per cpu on BizTalk doesn't seem to be doing it.