Biztalk Terminator
|
Biztalk Terminator is a tool which allows for common biztalk problems to be addressed by scripts provided by the biztalk team. Replaces terminate.vbs with more functionality including the ability to suspend, resume and terminate by date range. Powershell script functionality provided for performance tuning. Integration with mbvcleanupscripts.xml from the messagebox viewer utility
Biztalk has been in service for several years. Many problems have been resolved by the Biztalk Product group and CSS Engineers with SQL and WMI scripts. Terminator was created to accomplish 5 primary objectives:
1. A centralized repository for these scripts
2. A way for users to easily execute these scripts
3. A mechanism to auto-update these scripts
4. MBV Integration which allows users to easily resolve common BizTalk database integrity issues identified by the BizTalk MessageBoxViewer tool.
5. An automated way to improve performance on a Biztalk Group by tuning with standard tunings that are known to improve Biztalk Performance
Minimum Permissions required to run the Terminator:
1. The user running the terminator should be a member of the Biztalk Server Administrators Group.
2. Remote Registry rights to all BTS Servers in the group (According to support.microsoft.com/kb/314837, the minimum rights to read remote registry is based on the security rights to the HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurePipeServers\winreg key. Whoever has rights to this key can access the box's registry remotely.)
3. SQL SysAdmin permission required for some tasks
4. In order to have appropriate permissions on a Windows 2008, Vista, or 7 machine with User Account Control Enabled, the user must right-click and choose "Run as Administrator" when launching Terminator. If using Click-Once deployment to launch Terminator directly from the web, Internet Explorer needs to be Run As Administrator.
Things that you should do before running this tool:
1. Back up your BizTalk databases
2. Stop all hosts instances (including isolated hosts)
3. Stop all BizTalk SQL Agent jobs
4. Fully understand the task that you will run before executing it
5. Install PowerShell 2.0 on the machine running the tool.
The license of this software is Freeware, you can free download and free use this server utility software.