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

 

Published 03-29-2004 11:03 AM by Patrick Wellink
Filed under: