Sep 8

Monitoring SQL Jobs using BizTalk360 Custom Widgets

In the BizTalk360 8.0 release, a new feature dashboard was introduced. Dashboard integration is a useful capability to show the important activities in a single view. It can be utilized in the Operations and Analytic’s sections. Team members can take advantage by creating separate dashboards for different purposes. A global dashboard is created by default, it is shared to all the users in … Continue reading Monitoring SQL Jobs using BizTalk360 Custom Widgets

By Senthil Kumar

May 21

Monitor BizTalk SQL Jobs using BizTalk360

When you install and configure your BizTalk server environment a bunch of SQL jobs gets installed and scheduled automatically. SQL Jobs are crucial to keep the health of your environment. SQL jobs are responsible for variety of things in a BizTalk environments. Some of them include Moving Tracking Data from BizTalk Message Box database to … Continue reading Monitor BizTalk SQL Jobs using BizTalk360

By Saravana

May 10

BizTalk 360 – SQL Server Dashboard

BizTalk 360 provides a SQL server dashboard to view information that’s relevant to BizTalk Server. The screen shot below shows the SQL Server dashboard. Why do we need SQL Server information in a BizTalk monitoring and support tool? The heart of BizTalk server is the message box and it’s supporting databases like tracking, bam, SSO, … Continue reading BizTalk 360 – SQL Server Dashboard

By Saravana

Aug 23

Description of SQL Jobs used by Biztalk Server

MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb Detects when a BizTalk Server host instance (BTSNTSvc.exe) has stopped responding. The job then releases the work from the host instance so a different host instance can finish the tasks. MessageBox_Message_Cleanup_BizTalkMsgBoxDb Removes all messages that are not referenced by any subscribers in the BizTalk MessageBox (BizTalkMsgBoxDb) database tables. MessageBox_Parts_Cleanup_BizTalkMsgBoxDb Removes all message parts that … Continue reading Description of SQL Jobs used by Biztalk Server

By Saravana