Category name:BizTalk

Speeding up Biztalk on your Laptop

March 29, 2004 / Comments Off on Speeding up Biztalk on your Laptop

I have installed Biztalk 2004 on my laptop. And it works. It is not very speedy but ist works.


To speed up the processing i disabled all transactional functionality in SQL server by setting the transaction model to Simple. This makes it a little bit faster. First all my submissions gave a timeout but after setting the recorvery model in SQL to Simple it works fine.


Here is the query :


SELECT ‘ALTER DATABASE [‘ +  RTRIM(LTRIM(NAME))+’] SET RECOVERY SIMPLE’ FROM SYSDATABASES WHERE NAME NOT IN (‘TEMPDB’,’MASTER’,’MODEL’,’MSDB’)


This will speed up almost every laptop running SQL Server.


Pat


  • Recent Posts
  • Recent Comments
  • Archives
  • Categories
  • Meta