BizTalk is shipped out with a total of 13 SQL Agent jobs. Experienced BizTalk professionals know that all the BizTalk SQL Server Agent jobs except the MessageBox_Message_Cleanup_BizTalkMsgBoxDb job should be enabled and running successfully. Besides this job the other jobs should not be disabled!

However one of the most common and important tools to resolve problems that happens in BizTalk Server is the BizTalk Terminator tool (you can know more about this tool here). Terminator provides the easiest way to resolve most of these issues identified by the Monitor BizTalk Server Job.

Nevertheless, before running the Terminator tool, you must always make sure that:

  • you have a BizTalk Backup of your databases
  • all the BizTalk hosts instances have been stopped,
  • and all BizTalk SQL Agent jobs have been disabled.

Unfortunately, through SQL Server Management Studio console there is no easy way to disable or enable all jobs, forcing us to go one on one to disable or enable them.

disable-BizTalk-SQL-Server-Agent-jobs

This query will disable all the BizTalk SQL Server Agent jobs (including the MessageBox_Message_Cleanup_BizTalkMsgBoxDb):

update msdb.dbo.sysjobs set [enabled] = 0 where [name] = 'Backup BizTalk Server (BizTalkMgmtDb)'
update msdb.dbo.sysjobs set [enabled] = 0 where [name] = 'CleanupBTFExpiredEntriesJob_BizTalkMgmtDb'
update msdb.dbo.sysjobs set [enabled] = 0 where [name] = 'DTA Purge and Archive (BizTalkDTADb)'
...
update msdb.dbo.sysjobs set [enabled] = 0 where [name] = 'TrackedMessages_Copy_BizTalkMsgBoxDb'
update msdb.dbo.sysjobs set [enabled] = 0 where [name] = 'MessageBox_Message_Cleanup_BizTalkMsgBoxDb'

After all the task are complete we need of course to enable and start everything. This query will enable all the BizTalk SQL Server Agent jobs (with the exception of MessageBox_Message_Cleanup_BizTalkMsgBoxDb):

update msdb.dbo.sysjobs set [enabled] = 1 where [name] = 'Backup BizTalk Server (BizTalkMgmtDb)'
update msdb.dbo.sysjobs set [enabled] = 1 where [name] = 'CleanupBTFExpiredEntriesJob_BizTalkMgmtDb'
update msdb.dbo.sysjobs set [enabled] = 1 where [name] = 'DTA Purge and Archive (BizTalkDTADb)'
...
update msdb.dbo.sysjobs set [enabled] = 1 where [name] = 'TrackedMessages_Copy_BizTalkMsgBoxDb'

The SQL queries can be found and download on Microsoft TechNet Gallery:
SQL Query to Disable All BizTalk SQL Server Agent jobs
Microsoft TechNet Gallery

 

SQL Query to Enable All BizTalk SQL Server Agent jobs
Microsoft TechNet Gallery

Probably this will be the first post of a series about “How to take control of your environment”, especially how to take back the control of your environment from the mistakes of developers. And don’t get me wrong I am mainly a developer but I also play the role of the administrator and sometimes I also make mistakes… especially this one that I will talk about.

Who are careful to disable the tracking options for all the artifacts before publish the solution in production environment?

Well I sometimes forget to disable tracks event in orchestration: orchestration start and end, Message send and receive and Shape start and end; and sometimes we actually don’t need to track all this information, they will be there because someone forgot to disable it. Most important this information is only useful for orchestration debugger purpose when things are failing and we always can at any time turn it on for a specific application or orchestration, we don’t need that options active for all the applications.

What’s the implications of these settings being active in production?

“Document tracking can impact performance throughout BizTalk, not just Orchestration. For Orchestration, you should realize that Orchestration Event Tracking is on by default. This is useful during development and testing since Orchestration Events are required for Orchestration Debugger. However, if you do not intend to debug an Orchestration directly in production, you should turn Orchestration Event Tracking off. Orchestration Events are eventually moved to DTA_DEBUGTRACE table in BizTalkDTADB by TDDS. We have seen slow read/writes to this table once it gets large (several hundred thousand rows). What is considered large may vary due to your SQL Server hardware. In the end, if TDDS cannot move data efficiently into BizTalkDTADB, data is accumulated in BizTalkMsgBoxDB. Large MsgBoxDB can cause all of your hosts to slow down, and eventually lead to throttling.“ by Everett Yang (see: Thoughts on Orchestration Performance)

So as BizTalk Server processes more and more data on your system, the BizTalk Tracking (BizTalkDTADb) database may continue to grow in size that can causing poor disk performance.

Should I disable global tracking option?

By default, global tracking is enabled when you install BizTalk Server and if you are having performance issues in your environment that are momentarily addressed by purging the BizTalk tracking database, you may consider turning off global tracking, again momentarily, so that BizTalk stop collecting tracking information. You can accomplish that by modifying the group-level settings:

  • In the BizTalk Server Administration Console, expand BizTalk Server Administration, right-click BizTalk Group, and then click Settings.
  • In the BizTalk Settings Dashboard dialog box, on the Group page, do the following:
    • Disable “Enable group level tracking” option

BizTalk-Settings-Dashboard-Enable-group-level-tracking

However I advise you to do this only cases of emergency when you are having performance issues in production environment otherwise you should left this option enable at all time, why? Because turning off global tracking disables the tracking interceptors for the entire BizTalk Server group, which means, BizTalk Server will not track any events in its tracking tables. And sometimes we need to enable tracking for some artifacts.

So what’s the alternative?

The alternative is to configure for each application in each artifact: orchestrations, schemas, ports … the correct tracking settings. However this is a thankless and unpleasant task, because we have to go into all artifacts, especially in schemas, in order to configure them properly.

The first option to easily accomplish this task is to:

  • Go to the BizTalk Administration Console and Select “All Artifacts”
  • Select “Orchestrations” option and then select all the orchestrations available
  • Click “Tracking…” option in the right panel under “Selected Items” panel

BizTalk-Administration-Console-All-Artifacts-tracking

By configuring the tracking options this will apply for all the selected orchestrations with only one operation. This will works fine for all the artifacts… except schemas! Because in schemas you will need to go one by one.

The second option is using PowerShell script to accomplish this task, you could also do it with C# code but I think that PowerShell is a more familiar language for the administrators or sys admins.

How can I automate this task?

Windows PowerShell is a Windows command-line shell designed especially for system administrators and can be used by BizTalk administrators to help them in automating tasks.

This is a simple script to disable all tracking settings for all the artifacts in your BizTalk Server Environment:

# Disable tracking settings in orchestrations    
$Application.orchestrations | 
%{ $_.Tracking = [Microsoft.BizTalk.ExplorerOM.OrchestrationTrackingTypes]::None }

# Disable tracking settings in Send ports       
$disablePortsTracking = New-Object Microsoft.BizTalk.ExplorerOM.TrackingTypes
$Application.SendPorts | 
%{ $_.Tracking = $disablePortsTracking }

# Disable tracking settings in Receive ports
$Application.ReceivePorts | 
%{ $_.Tracking = $disablePortsTracking }

# Disable tracking settings in pipelines        
$Application.Pipelines | 
%{ $_.Tracking = [Microsoft.BizTalk.ExplorerOM.PipelineTrackingTypes]::None }

# Disable tracking settings in Schemas
$Application.schemas | 
	?{ $_ -ne $null } |
	?{ $_.type -eq "document" } |
	%{ $_.AlwaysTrackAllProperties = $false }

The script can be found and download on Microsoft TechNet Gallery:
BizTalk DevOps: How to Disable Tracking Settings in BizTalk Server Environment (5.7 kB)
Microsoft TechNet Gallery

Exciting news… Version 1.7.0.1 of BizTalk Mapper Extensions UtilityPack for BizTalk Server 2013 is now available!

Project Description

BizTalk Mapper Extensions UtilityPack is a set of libraries with several useful Functoids to include and use it in a map, which will provide an extension of BizTalk Mapper capabilities.

Here’s the change-log for this release:

  • Fixes bugs in the String Replace Functoid
What’s new in this minor version?

This is a minor release of this project that is intended to fix some one minor problem reported in the String Replace Functoid.

It was reported that when trying to be replace a Carriage Return\Line Feed (“\r\n”) inside an element the functoid didn’t work and the reason way this happen is that the XSLT code will translate the string “\r\n” to “\\r\\n”. This release will fix that problem. It may not work for every “special characters” however if you find some more problems you can report them that we will address them.

You can found and download Source Code, Application Binaries and Documentation in CodePlex BizTalk Mapper Extensions UtilityPack home page:

BizTalk Mapper Extensions UtilityPack
CodePlex

 

or from MSDN Code Gallery:

BizTalk Mapper Extensions UtilityPack for BizTalk Server 2013 (628.8 KB)
Microsoft | MSDN Code Gallery

This last few days were quite busy in terms of speaking engagements. In less than 1 months I was invited to speak in 3 events: BizTalk Innovation Day Oslo, LIX Edition of SQLPort Community (Porto – Portugal) and in SQLSaturday #341 – Porto, Portugal.

BizTalk Innovation Day Oslo 2014

The first one was in September 25 – BizTalk Innovation Day Oslo, in which I am also a member of the organization team – BizTalkCrew, this was the third consecutive year that this event was third consecutive year but the first time in Oslo, since the others were held in Stavanger. Around 60 attendees + speakers + event organizers, attended the event especially from Norway and Sweden, 5 Microsoft Integration MVP’s present, 3 Sponsors (Microsoft, Bouvet and BizTalk360) and an incalculable number of networking hours these are some of the numbers that reflect the success of this event. These are some of the numbers that reflect the great success of this event!

BizTalk-Innovation-Day-Oslo-Speakers

This was a special event for me! Because after 1 year and a half of hard work I finally release and public announce my free Book about “BizTalk Mapping Patterns & Best Practices” – a 400-page recipe for BizTalk Developers to develop effective, robust, and organized maps that he has previous announce during the BizTalk Summit 2014, London event.

Sandro-Pereira-announcing-his-book-BizTalk-Innovation-Day-Oslo

You can download it at BizTalk360 website here.

My Session – The new Transform Designer available in BizTalk Services

My session was about the new Transform Designer available in BizTalk Services were I addressed the basic differences between the BizTalk Server Mapper and the new Mapper in BizTalk Services, the challenges present while migrating current BizTalk Server maps and how can this task be accomplished. And of course how can we accomplish some of the basic transformation tasks like grouping, shorting and condition transformations. I end my presentation with a very complex transformation challenger that took me a week to solve: mapping a SAP invoice to an EDI Invoice document and wrapping up with the “the good, the bad and the ugly” features of the new Transform Designer.

Sandro-Pereira-at-BizTalk-Innovation-Day-Oslo-2014Sandro-Pereira-at-BizTalk-Innovation-Day-Oslo-2014-2

You can see the full story of the event here: BizTalk Innovation Day, Oslo – story of the day

 

LIX Encontro da Comunidade SQLPort

The second event was a 20-minute talk in the LIX Edition of SQLPort Community meeting in Porto, Portugal about the Concepts and challenges of Enterprise Integration and how can BizTalk Server and BizTalk Services can address them and help organizations in their needs. An Introduction to BizTalk Server. What is? What does BizTalk do? And an Introduction to BizTalk Services. What is? What does BizTalk Services do?

Sandro-Pereira-speaking-at-LIX-SQLPortSandro-Pereira-speaking-at-LIX-SQLPort-cloud-challengesSandro-Pereira-speaking-at-LIX-SQLPort-Integration

 

SQLSaturday #341 – Porto

This was the fourth time that this conference took place in Portugal, but it was the first time that was held in Porto, so was very proud and honor to be selected by the attendees to speak in my first SQLSaturday and in particular to be in my home town. The event was a great success! 22 sessions divided into three tracks, national and international speakers and despise I don’t have official numbers, more than 200 attendees must have passed by the event during the day.

SQLSaturday-341-Porto-Speakers

My Session – Introduction to Microsoft Azure BizTalk Services

I had the pleasure to speak at SQLSaturday #341 Porto to a bright young audience that never heard about BizTalk Server/Services… Hoping to open the door for a new integration “BizTalk” genius and why not working with me!

Sandro-Pereira-at-SQLSaturday-341-PortoSandro-Pereira-SQLSaturday-341-Porto-2Sandro-Pereira-at-SQLSaturday-341-Porto-3

In this session spoke about the existent functionalities in the new integration services in the cloud: Microsoft Azure BizTalk Services: EAI (Enterprise Application Integration) and EDI (Electronic Data Interchange), the challenges in moving from BizTalk Server to BizTalk Services. And the evolving challenges of Enterprise Integration.

 

I was also honor to represent my company DevScope, gold sponsor of this event, in the awards ceremony session. DevScope has offered an entry to Microsoft Azure Machine Learning Master Class that will be held in November 22 in Porto

Sandro-Pereira-awards-ceremony-sessionSQLSaturday-Attendees

This post is for the BizTalk Server and SQL Server Portuguese Community, will be held on October 15, 2014 between 18:30 – 21:50 the LIX SQLPort Community Meeting at the Science and Technology Park of University of Porto (UPTEC) in Oporto.

SQL-Port-Portugal-logo

LIX Encontro da comunidade SQLPort

Realiza-se no dia 15 de Outubro de 2014, o LIX Encontro da comunidade SQLPort, que tem como objectivo a partilha de experiências e conhecimento entre os profissionais e entusiastas de SQL Server em Portugal. O evento vai ser realizado no PORTO, no auditório da UPTEC, pelas 18:30, sendo a entrada livre para todos os inscritos.

Os nossos oradores confirmados são Sandro Pereira (MVP), Ivan Campos, Rui Marinho, Niko Neugebauer (MVP), Fabiano Amorim (MVP) e Murilo Miranda (MVP)

As sessões estão sobre segredo absoluto mas será um evento a não perder!

A Agenda…

18:30: Abertura e recepção;

19:30: Community News

19:10: 3 Apresentações – Oradores

20:10: Networking / Coffee Break;

20:30: 3 Apresentações – Oradores

21:30: Sorteio de prémios

21:30: Fim do evento;

22:00: Jantar livre

Data Evento: 15 Outubro 2014 – 18:30H

Local do Evento: Parque de Ciência e Tecnologia da Universidade do Porto (UPTEC) | Rua Alfredo Allen, n.º455/461 | 4200-135 PORTO | Portugal

Saiba mais sobre o evento na página da Comunidade SQLPort.

O evento é gratuito! De que está à espera? Reserve já o seu lugar aqui e participe!

Estamos a sua espera.

I’m proud to announce that I will present a session about BizTalk Services: “Introduction to Microsoft Azure BizTalk Services” at SQLSaturday #341 Porto (Portugal) on October 18th, 2014! I’m excited and it is truly an honor because this is the first time I submit a session to this kind of event and I have been selected by the attendees to speak at a SQLSaturday in my home town.

SQLSaturday-341-Porto-2014-logo

This is the fourth time that this conference takes place in Portugal, but it is the first to be held in Porto, and will have three “tracks” with parallel sessions in three different topics Administration/Development (DBA), Business Intelligence (BI) and Development (.NET).

About my session…

Historically, both EAI and EDI has been performed through BizTalk. With this preview we will give an early glimpse into how Microsoft envisions these types of integration scenarios being addressed in a Platform as a Service (PaaS) based environment.

In this session we’ll look at the existent functionalities in the new integration services in the cloud: Microsoft Azure BizTalk Services: EAI (Enterprise Application Integration) and EDI (Electronic Data Interchange), how to manage the exchange of EDI messages and trading partners through BizTalk Services Portal; Support Flat files, schemas and transformations (maps). And at the challenges in moving from BizTalk Server to BizTalk Services.

Session Level: Beginner

About my coleagues at DevScope…

The event will have well known international speakers, however I want to highlight my coleagues at DevScope that were also invited to deliver sessions at this event. And the contributions of DevScope range from Cloud Services to Server Automation or Mobile Development. There will be plenty of opportunities to meet us in our hometown:

See more about DevScope contribution here: SQLSaturday comes to Porto on Oct 18th

Event scheduler…

My session will start at 12 PM in the Development (.NET). track – room 3 and I will be waiting for you!

my-session-scheduler-in-SQLSaturday-Porto-2014

Chech the full event scheduler here: SQLSaturday #341 Event Scheduler

This is a FREE training event for Data Professionals, Students & Enthusiasts, which shall be held on 18th October 2014 at ISEP – Rua Dr. António Bernardino de Almeida, 431. Admittance to this event is free, all costs are covered by sponsorships.

Please register quickly here: https://www.sqlsaturday.com/341/register.aspx because seating is limited, and let friends and colleagues know about the event.

I public announced for the first time that I was working in an eBook about BizTalk Mapping Patterns and Best Practices, and that it would be published for free, this March during BizTalk Summit 2014 London… Well folks, it’s that time to announce that “BizTalk Mapping Patterns and Best Practices” book – a 400-page recipe for BizTalk Developers to develop effective, robust, and organized maps – is now finally available for you to download at BizTalk360 website here.

BizTalk-Mapping-Patterns-And-Best-Practices

The “BizTalk Mapping Patterns and Best Practices” book is a reference guide mainly intended for BizTalk developers to make their day-to-day lives easier. The book offers insights on how maps work, the most common patterns in real time scenarios, and the best practices to carry out transformations and has as technical reviewers Steef-Jan Wiggers, Nino Crudele, Michael Stephenson and José António Silva. I had been working on this over the last one year, and my original idea of publishing these information as a blog changed in the due course to become a white paper, then finally to a “Community eBook” with about 400-pages and contributions from so many people. I need to thanks BizTalk360 to accept the challenge of publishing its first book and make it available to the community and my employer, DevScope, for given me a lot of leverage to spend time writing this book, but also to actively contribute for the community of BizTalk with articles, blog and conferences.

I would also like to thank my fantastic team of Technical Reviewers composed by three Integration MVP’s: Michael Stephenson, Nino Crudele and Steef-Jan Wiggers and for the person responsible for the initial idea: José António Silva. Thank you for accepting the challenger and thank you for the incredible effort and time to increase the quality of the book. And also to my friend Sónia Gomes (http://ideiasaoscaracois.com) for creating this amazing cover for the book.

Key Features
  • Direct Translation Pattern: Simply move data to a different semantic representation without any manipulation or transformation.
  • Data Translation Pattern: Similar to Direct Translation Pattern with additional step of data manipulation or transformation to match the target system format.
  • Content Enricher Pattern: Set up access to an external data source (say, a database) to enhance the message with missing information.
  • Aggregator Pattern: Similar to Content Enricher Pattern; difference in mapping technique. Multiple inbound requests mapped to single outbound request.
  • Content Filter Pattern: Opposite of Content Enricher Pattern; remove unnecessary items from message (even based on condition) and send what is exactly required
  • Splitter Pattern: Opposite of Aggregator Pattern; single inbound request to be mapped to several outbound requests
  • Grouping Pattern: Example – shopping catalogue where items are grouped under categories like Sports, Women Cosmetics, Electronics, Computers, and so on.
  • Sorting Pattern: In most scenarios, Grouping Pattern and Sorting Pattern will be bound together
  • Conditional Pattern: To receive only portion of the data from the message, apply a condition statement to filter the result set at the source.
  • Looping Pattern: For instance, a record in the source system may occur multiple times in the input file. They need to be transformed according to the target system
  • Canonical Data Model Pattern: Ensures loose coupling between applications; if new application is added, only the transformation between the Canonical Data Model has to be created.
  • Name-Value Transformation Pattern: Target system requires a Name-Value Pair (NVP) structure; or the source system has a NVP structure and the target requires a hierarchical schema

Click here to download your free copy of the book.

Why I did not choose a “proper” publisher?

Some people have asked me why I didn’t publish my book in a real proper publisher like Apress, Packt Publishing or others and the reason is simple… I could easily and had the chance to publish but it would be a paid book and what I really wanted was to create and deliver to the community my first book (I don’t know if I will write or not more books) for free as a way to thank you for the affection and support that all of you have given me in the last years.

BizTalk360 was the proper choice because I know the people and I know I could count on them to publish making it available to the community for free and promote the book.

When was the book released?

The book was public announced during the BizTalk Innovation Day, Oslo (Norway) 2014 event and I could not have chosen a better place and audience to present my book because the idea of creating this book started after a session of one of our events: BizTalk Innovation Day Oporto, the venue was really amazing in a kind of nightclub for event (actually MESH is also a nightclub J) and the Norwegian audience is really amazing and I have good friends there.

Here is the moment of the official announcement:

983808_10154679875790215_4831962891112983455_n10712741_10154679875665215_8135613065073045386_n
10639568_10154679875950215_5466833305087056286_n10689790_10154679875865215_4412905719135280171_n

Please give me your feedback

Your opinion is very important to me. I appreciate your feedback and I will use it to evaluate changes and make improvements in the book and future projects.

book-critic

Download the book for free

BizTalk-Mapping-Patterns-Best-Practices-banner

The book if available for you to download for free at BizTalk360 website here: BizTalk Mapping Patterns & Best Practices

I miss the old BizTalk Hotrod Magazine, of my knowledge, there isn’t no other type of magazine about BizTalk Server. And the only thing we have approximately to that is the Flipboard BizTalk Magazine that I have weekly published throughout these last months.

You can find the BizTalkMagazine into Flipboard in in your favorite device Apple (iPhone, iPad), Android, Windows 8, and so on… or simply through the Internet browser at: https://flipboard.com/section/biztalkmagazine-bMJFWI

I start this project because I didn’t have the knowledge and the time required to create a PDF magazine similar to the BizTalk Hotrod Magazine, and Flipboard gave me an easy and simple way to share content in a type of magazine format.

Now it seams a little limited and after all this months I would like to take the magazine to a new level and recreate some of the concept of BizTalk Hotrod magazine, inviting authors to write articles to be published and share other resources like tools, scripts, adapters and so on… probably launching a magazine every month or quarterly.

To try this concept I decided to publish a beta version of the magazine as a proof of concept that now is available for you to download here: BizTalk Magazine – September 2014 Edition – probably the magazine name should be different.

Capture

This first edition contains:

  • BizTalk Innovation Day, Oslo – Norway
  • BizTalk Server 2013: Step-by-Step to implement Unit Testing in Schemas and Maps
  • "INTEGRATE – 2014"– Announcing the Global BizTalk Summit, Microsoft Campus, WA. Dec 3-5, 2014
  • BizTalk Administrator Deep dive course
  • Exposing data through BizTalk Service Hybrid Connections
  • BizTalk Server SQL Agent Jobs

Have a nice read! And If you have any suggestions feel free to comment, your feedback is important.

In the last few weeks I have been doing BizTalk project migrations successfully from BizTalk Server 2006 and Visual Studio 2005 to recent version: BizTalk Server 2010/VS 2010 or BizTalk Server 2013/VS2012. In most of the scenario this is a simple task and regarding to Visual Studio we basically just need to open the “old” solution with the “new” Visual Studio and it will try to convert the solution using the Visual Studio Conversion Wizard tool, check more details in one of my previous post: BizTalk 2010 – Migrate an old BizTalk Visual Studio solution to Visual Studio 2010.

Of course this part is just the Visual Studio project migration, and in some cases we need to make adjustments to our solution.

However recently I face a strange problem when I was trying to convert the Visual Studio solution, every time I tried it gave me the following error:

“Unable to read the project file “…\MyProject.btproj.user”. The project file could not be loaded. Root element is missing.”

The-imported-project-file-could-not-be-loaded-Root-element-is-missing

CAUSE

“*.btproj.user” file. This is a XML file that contains not only the BizTalk deployment Settings but also several personal user settings like References path, test file names and so on.

I’m not sure what did happen with this file while copying the project to the new server, or during it’s time life in the former development server. However when I check the file system for this file I noticed that the file was empty:

MyProject-btproj-user-file

SOLUTION

To solve this problem you just need to delete this User configuration file (*.btproj.user) from the file system and try to import de project or convert the solution again.

BizTalk-Solution-imported-successfully

BizTalk Health Monitor is a snap-in, basically it’s the same of BizTalk MsgBoxViewer tool that we used monitor a BizTalk environment by gathering all information of a BizTalk group and detecting any issues, non-critical or critical warnings to detect any potential problems in advance, but in this case is integrated more closely with the BizTalk Administration Console to provide BizTalk administrators a quick and complete dashboard of a BizTalk group which will help them monitor the health of their BizTalk platform.

You can see more info about BizTalk Health Monitor (BHM) at:

BHM was originally released as a new feature with BizTalk Server 2013 R2 but luckily for us Microsoft decided to release a standalone version of BHM for use with BizTalk Server 2010 and BizTalk Server 2013.

You can download the standalone version of BHM from Microsoft Download Center here: BizTalk Health Monitor

How to install BizTalk Health Monitor snap-in

Prerequisites:

  • BizTalk Server 2010 or 2013 should be installed and configured.
How to register BizTalk Health Monitor Snap-In

After you download and unzip the BHM.ZIP file from the Microsoft Download Center, you the “InstallUtil.exe” which comes with BizTalk Health Monitor tool to register the BHM snap in.

Important: Unzip the BHM.ZIP to a final destination before you register the snap-in for example: C:\Program Files (x86)\Microsoft BizTalk Server 2010\SDK\Utilities\BHM. Once you register the BizTalk Health Monitor Snap-In you cannot delete the folder or BHM will stop working

To accomplished that we need to:

  • Open a command prompt as an administrator
  • Navigate to the directory file where you unzipped the BHM.ZIP file
    • For example: C:\Program Files (x86)\Microsoft BizTalk Server 2010\SDK\Utilities\BHM
  • And from the command prompt type:
    • InstallUtil.exe MBVSnapIn.dll
  • And hit enter. This step will do some registry changes and register the SnapIn to be used

 

How to integrate BHM Snap-In into BizTalk Admin Console

Important note: BHM Snap-In can be used independently and need not to be integrated with BizTalk Administration Console. The handicap of this approach is that a BizTalk Administration will need to use two different places/tools to monitor and administrate the environment.

To be easier and more convenience for BizTalk Administrators BHM Snap-In can also be integrate it so that it can be used with BizTalk Administration Console.

To accomplished that we need to open a 32-bit Microsoft Management Console (MMC):

  • Click Start, click Run, type:
    • mmc /32
  • Press enter or click OK. This will open a new 32-bit version of MMC (MMC32).
  • From MMC console, go to File menu and select “Options…” option
    • In the text box, replace “Console1” for “BizTalk Administration Console”
    • In the Console mode combo box, select “User mode – full access”
    • And confirm that the option “Do not save changes to this console” is uncheck

MMC-console-properties

  • From MMC console, go to File menu and select “Add/Remove Snap-in…” option

MMC-window-Add-Remove-Snap-in

  • From the “Add or Remove Snap-ins” window, add following snap-ins and then click Ok
    • Microsoft BizTalk Server Administration
    • BizTalk Health Monitor

MMC-window-Add-or-Remove-Snap-ins-selection

    • You can add the snap-ins by selecting them from the “Available snap-ins” list and click “Add >”
    • Is recommend that you respect the order present in the “Selected snap-ins” list as showed in the picture above
  • This will generate for us a new MMC which contains both the BizTalk Server Administration and BizTalk Health Monitor. And by now your new MMC is ready which shows both the BizTalk Server Administration and BizTalk Health Monitor

new-BizTalk-Administration-Console

Now you might want to save this as a new .msc file so that you don’t have to repeat these steps again but before we complete the creation process of the “new” BizTalk Administration Console, I recommend that you navigate to the BizTalk Server Installation folder:

  • Example: C:\Program Files (x86)\Microsoft BizTalk Server 2010
  • And rename “BTSmmc.msc” file, for example: “BTSmmc-old.msc”

This because we will save the “new” BizTalk Administration Console as “BTSmmc.msc” so that you don’t need to create new shortcuts or having different ways to access the BizTalk Administration Console – however this step is optional!

To finished the creation process of the “new” BizTalk Administration Console

  • From MMC console, go to File menu and select “Save As…” option:
    • Give a name and then save it.
      • Access to BizTalk Server Installation folder
        • C:\Program Files (x86)\Microsoft BizTalk Server 2010
      • Save the file as “BTSmmc.msc”

From next time onwards, when you open the BizTalk Server Administration Console

start-BizTalk-Administration-Console

The “new” BizTalk Administration Console will be incorporated with the BizTalk Health Monitor

BizTalk-Administration-Console-with-BizTalk-Health-Monitor

You can download the standalone version of BHM from Microsoft Download Center here: BizTalk Health Monitor