Integration Experts – Dipesh Avlani

BizTalk Server, WCF, WF and Cloud computing…

BizTalk 2013 Licensing – cheaper? Maybe, maybe not!

Posted by DipeshA on March 25, 2013

Note this is not the official Licensing document for BizTalk Server! Please consult Microsoft before making any purchase decisions.

Overview

With the BizTalk 2013 (english locale) SKUs hitting the Microsoft sites for purchase in April. It is important to note an important change Microsoft have made to the BizTalk 2013 licensing model. Up till now (i.e. BizTalk 2010), BizTalk followed a per processor model (ie a physical socket) . With BizTalk 2013, Microsoft have changed the model to be per core. Just like SQL Server.

But what does core licensing mean? How does it affect your costs? For this, one must understand the concept of a core.

As per the wiki, a core is a central processing unit within a processor. So a dual core processor would have 2 cores, a quad core would have 4 cores and so on.

The above is a dual core processor with 2 cores.

The per processor model of licensing has its own problems. One could buy a processor license for a quad core processor and still end up paying for one processor and get the processing power of 4 processors. With the new model, a license has to be purchased for every core. That is 4 licenses would be required in this particular example. Core prices are costed as the 1/4 of the processor license cost.

Lets do some cost analysis between the two model for the same spec (prices are approx):

Per Processor (quad-core): ~$40,000 x 1 = ~$40,000

Per Core (quad-core):  ~$10,000 x 4 = ~$40,000

From the above, there is not much difference in this example. However, if you ended up using 5 cores for argument sake, what do the numbers look like between the two models?

Per Processor (quad-core + single core): ~$40,000 x 2 = ~$80,000

Per Core (quad-core + single core):  ~$10,000 x 5 = ~$50,000

There you have significant cost savings for almost $30,000 with the new model!

Some Key-points

  • All the cores in the server must be licensed.
  • Licenses can be purchased in pack of two.
  • Minimum of 4 core licenses required (if your server has less than 4 cores, ex: single core and dual core machines)
  • Actual number of core licenses required may vary based on processor type and core factor.

Prices

The estimated price for a core license is approximately $10,835 for Enterprise and $2,485 for Standard.

How do you calculate the cores?

In order to calculate the cores, core-factor must be understood. A core-factor is different for different brands of processors.

Type Core-factor
Single Core 4
Dual Core 2
AMD processors (6 cores or above) 0.75
All others 1

So if you were using a 12 core AMD processor, the license cost would be calculated as follows:

AMD: 12 cores x 0.75 = 9 core licenses required.

Intel: 12 cores x 1 = 12 core licenses required.

Conclusion

From the above, it is apparent that the licensing costs entirely depend on how BizTalk Server is deployed and the type of hardware. It affects different companies in different ways.

Posted in BizTalk 2013, General | Tagged: , | Leave a Comment »

BAM_AN packages not executing by SQL jobs

Posted by DipeshA on January 25, 2013

I recently hit an issue with the BAM_AN packages executed through a SQL job  failing with the following message.

Object reference not set to an instance of an object.

at…. UpdateDataSourceAndGetAnnotation(String cubeName, String asServerName, String asDatabaseName, String ssServername, String ssDatabaseName)  

The reason was the account under which my SQL jobs were running did not have access to the Analysis Services. Solution was to right click on the root node –> properties and add the account under the security tab and it started working.

Posted in BAM, General | Tagged: , , | Leave a Comment »

BAM: Regenerating data for non-RTA views

Posted by DipeshA on December 19, 2012

If you have log-shipped or moved your BAM databases to another environment, you might find that the legacy data in your non-rta view vanishes and only recent data is displayed.

This defeats the purpose of having scheduled aggregations to view data over months. However, there is a way to “reset” your cubes.

In the BAMPrimaryImport database, there is a table called ‘bam_Metadata_AnalysisTasks’. This table keeps track of range of records that the cube processed each time it ran. This range is also used to define the view ‘bam_<cubename>_CompletedInstancesWindow’ that is used to populated the staging tables for aggregation.

The trick is to delete all the records from this table in the BAMPrimaryImport database.

Delete from bam_Metadata_AnalysisTasks where CubeName=’<cubename>’

GO

Insert INTO bam_Metadata_AnalysisTasks(CubeName,MinRecordID,MaxRecordID,LastStartTime,LastEndTime)

VALUES (‘<cubename>’,NULL,NULL,NULL,NULL)

Note: Run the above queries for all the cubes in question. DO NOT RUN IN PROD BEFORE TESTING.

After executing the above command, run the corresponding BAM_AN_<cubename> package. After this has completed, browse to the BAM portal and you will see all historical data again.

Cheers.

Posted in BAM, General | Tagged: , , , | Leave a Comment »

BAMAlerts – The activation state cache could not be updated.

Posted by DipeshA on December 18, 2012

If you have log shipped or detached/attached the BAMAlerts databases, you will have issues starting the notification service on the BizTalk server for BAM alerts. The reason for this, when these databases are restored, the the ‘Cross-Database Ownership Chaining’ option on the BAMAlertsApplication and BAMAlertsNSMain databases is disabled and greyed out. Greyed out because it can only be enabled via a script.

cross_chaining

To enable these options, run the following command (you need to be sys-admin):

–set chaining for a database

alter database BAMAlertsApplication set DB_CHAINING ON

GO

alter database BAMAlertsNSMain set DB_CHAINING ON

GO

—-

Once done, you should be able to start the BAM alerts notification service on the BizTalk Server.

Posted in BAM, BizTalk 2006/2009, BizTalk 2010 R2, BizTalk 2013, General | Tagged: , , , , | Leave a Comment »

Welcome BizTalk 2013 beta

Posted by DipeshA on November 9, 2012

Microsoft recently released the beta release of BizTalk Server 2013. The first good news is that the initial name (BizTalk 2010 R2) has changed to BizTalk 2013, indicating it will be a major release, providing longer support to our customers!

The beta contains the following capabilities:
Integration with Windows Azure Service Bus – these are mainly out-of-the-box adapters for Windows Azure Service Bus (both messaging & relay)
Support for REST – seeing the web- & device-world move to a REST-oriented approach, it is a very good thing to see support for REST in BizTalk 2013. And this is not only for consuming, but also for exposing RESTful services!
SFTP adapter – this has been a request for years and it’s with great relief that a true SFTP adapter will be part of BizTalk 2013
ESB Toolkit – The ESB toolkit has been one of the most unclear parts of BizTalk since its inception. From guidance over toolkit and now ending up as part of the product. The configuration experience is much better, which is already good.
Dependency tracking – the administration console now shows the dependencies between artifacts
Other changes – enhanced SharePoint adapter, improvements in send ports…
Host Integration Server- that comes with the BizTalk license, also has some improvements in the following areas: DB2 integration, TI management, Support for MQ v7.5 & v7.1

Download Link:

 http://www.microsoft.com/en-us/download/details.aspx?id=35553

What first looked like a pure platform update (aligning with SQL Server 2012, Windows Server 2012, .NET 4.5) now has changed to a big upgrade with a lot of enhancements to the product.

Posted in Azure, BizTalk 2013, BizTalk Azure | Tagged: , , | Leave a Comment »

Determining Process IDs of multiple BizTalk Host Instances

Posted by DipeshA on September 21, 2012

For debugging, it is neccessary to attach the BizTalk host instance process to Visual Studio. However, if you have multple host instances, you cant tell which one is which.

I have found a PS script which gives you the process Ids of multiple host instances.
32Bit Hosts:
TASKLIST /FI “USERNAME ne NT AUTHORITYSYSTEM” /FI “IMAGENAME eq BTSNTSvc.exe” /SVC

64Bit Hosts:
TASKLIST /FI “USERNAME ne NT AUTHORITYSYSTEM” /FI “IMAGENAME eq BTSNTSvc64.exe” /SVC

Posted in BizTalk 2006/2009, BizTalk 2010, BizTalk 2010 R2 | Tagged: , | 3 Comments »

Creating a BizTalk 2010 R2 VM on Azure

Posted by DipeshA on August 31, 2012

If you have been wondering how to create a Biztalk VM on Azure, there is a very good article recently posted on The BizTalk Server Team Blog. Check it out here.

This post will walk you through the steps involved to create a virtual machine running BizTalk Server 2010 R2 (CTP) in the cloud.

Posted in BizTalk 2010 R2, BizTalk Azure | Tagged: , , | Leave a Comment »

BizTalk Server 2010 R2 (TAP) Available

Posted by DipeshA on August 15, 2012

The latest version of BizTalk is available (CTP). This Technology Adoption Program (TAP) is for BizTalk Server 2010 R2, the 8th BizTalk Server release from Microsoft.
BizTalk Server 2010 R2 delivers enhancements in the following feature categories:
  • Electronic Data Interchange
    • Updated standards support
    • IaaS offering
  • Messaging
    • Ordered delivery enhancements
    • HL7 standards update
  • Enhanced Visual Studio 2012, SQL Service 2012, Systems Center 2012 experience
  • Support for SQL Server 2012 High Availability
  • Integration with Windows Azure Service Bus and Workflow
  • Addition of REST adaptor for integrating with Restful endpoints
  • BizTalk Server Cloud IaaS offering for development and test scenarios

You can signup if you interested in being a part of this release.

Posted in BizTalk 2010 R2, General | Tagged: , , , | Leave a Comment »

SignalR & BizTalk

Posted by DipeshA on July 26, 2012

For those who have never heard about SignalR, it is an async .net library for building real-time web applications. This sounds so interesting that it can actually open another dimension for applications requiring realtime updates via BizTalk.

SignalR helps pushing data from the server to the client (not just browser clients). SignalR makes it dead easy and handles all the heavy lifting for you.

There is a very interesting article by Kent Weare which talks about SignalR and how it can be used with BizTalk.

http://kentweare.blogspot.com.au/2012/07/part-1-biztalk-signalr.html

Posted in BizTalk 2006/2009, General | Tagged: , | Leave a Comment »

BizTalk 2010 Certification Guide

Posted by DipeshA on July 16, 2012

If you are looking at getting BT 2010 certified, there is just the book out there that you will need to prepare for the exam 70-595. Authors include Johan Hedberg, Kent Weare & Morten La Cour. The book covers everything from BizTalk basics to WCF to RFID to BAM. Having said that, the book is to the point and compact enough to get you scoring soon!

Get a copy here:

http://www.packtpub.com/mcts-microsoft-biztalk-server-2010-certification-guide/book

Cheers!

Posted in BizTalk 2010 | Tagged: , | 1 Comment »

 
Follow

Get every new post delivered to your Inbox.