Jun 8, 2008

Biztalk SQL Server management and optimization

I found two great posts about biztalk server 2004/2006 DB optimization, deadlock solutions.
I suggest everyone who work with biztalk to read this posts.

  1. http://support.microsoft.com/kb/917845
  2. Biztalk core engine's WebLog - What you can and can't do with the Messagebox Database server.
Summery :
  • Don't enable/use statistics.
  • Shutdown the parallelism.
  • Don't built maintenance plan for indexes, use only bts_RebuildIndexes stored procedure, shutdown biztalk engine first.
  • Don't change the stored procedure code.

No comments: