Welcome back to a new post about BizTalk Server Tips and Tricks! And this time I would like to talk about a very important topic for BizTalk Administrators: BizTalk MarkLog tables. All the BizTalk databases that are backed up by the ‘Backup BizTalk Server’ job, which means all the default BizTalk databases (SSODB, BizTalkRuleEngineDb, BizTalkMsgBoxDb, … Continue reading BizTalk Server Tips and Tricks: How to properly maintain BizTalk MarkLog tables
Think about all the information that is stored in your BizTalk360 database – Alarms, Knowledge Base, various Settings. This data is very important for many reasons. Now imagine if all of the information just disappeared. Although it is a scary thought, it is highly unlikely that your company is not backing up your database. Let’s … Continue reading Have you Backed up your BizTalk360 Database?
In BizTalk360 support, we often face a lot of interesting issues and we thought we would bring out a series to discuss the different cases that come our way and how we dealt with them. A previous blog by my colleague spoke on the Culture variant issue, a very unique case. Recently we came across … Continue reading Challenges in BizTalk360 Licensing after Environment Changes
SQL Server is vital for any BizTalk environment, ensure maximum performance for the most demanding databases with a fast disk subsystem, consider using RAID 1+0 and SSDs for a high performance environment. In the majority of the BizTalk environments this is the first physical bottleneck you will face. When doing load testing you will find … Continue reading BizTalk Server Tip #17: Use fast disks for your BizTalk Database subsystem
BizTalk Developers, have you enabled DTA Purge and Archive (BizTalkDTADb) SQL job on your development machine?
In development machines, BizTalk developers normally tend to enable full body tracking of messages they process inside the BizTalk server for debugging purpose. As BizTalk Server processes more and more data on your system (over a period of time), the BizTalk Tracking (BizTalkDTADb) database continues to grow in size. Unchecked growth decreases system performance and … Continue reading BizTalk Developers, have you enabled DTA Purge and Archive (BizTalkDTADb) SQL job on your development machine?
Do you think you can use BTSDeploy on a remote BiztalkMgmtDb database server? I thought it will after looking at its parameter list, it takes a database server name and managment database name and an XML port configuration file as arguments. So, it sounded very normal for me to take it for granted we can … Continue reading BTSDEPLOY on a remote BiztalkMgmtDb database