none
BAM Analysis Usage and Best practices RRS feed

  • Question

  • Hi,

    I would like to know the following about BAM Analysis:

    What is the purpose of BAM Analysis Services

    What are the Best practices to implement BAM Analysis in a Production box

    Thanks!!

    Saturday, June 15, 2013 8:39 AM

Answers

  • BAM is a set of 5 databases and also requires SQL Analysis Services. A lot of people prefer to have a separate instance with SQL Analysis configured to server as the location for installing these databases.

    In regards to size, 80 to 100 GB is normally OK. It depends on how much data you wish to keep w.r.t the trends and analysis data. There are archive jobs that help you keep this database growth in check.

    Regards.

    • Marked as answer by Pengzhen Song Friday, June 21, 2013 10:42 AM
    Sunday, June 16, 2013 2:58 PM

All replies

  • Hi ,

    It is SQL Server Analysis Services associated with BAM Analysis database that keeps the aggregated historical data for Business Activities.

    And it is used by BAM where you want to have tracked data and report generation for over a certain period of time.


    I hope this helps!!!!!! If this answers your question, please mark it as "Answered". It will help to reduce visits to same post as it's already answered and will help guys with same question as yours without even posting it . Maheshkumar S. Tiwari|Team lead/Consultant(EDI/EAI)|iVision Software Pvt Ltd, Pune.

    Saturday, June 15, 2013 9:00 AM
  • BAM as the name implies stands for Business Activity Monitoring. In BizTalk it can be used for instrumenting your processes/orchestrations, message and process tracking. BAM is basically a data warehousing extension and you can generate message trends, volumes and other reporting data just by adding the BAM functionality to the orchestration. The skills through are those required for Business Intelligence and not integration/development.

    Regards.

    Saturday, June 15, 2013 1:21 PM
  • Can you let me know what are the best practices for implementing BAM analysis services? What should be the size of the DB, is it preferable to run on a separate SQL server other than where BizTalk Databases have been deployed? What should be the privileges provided? etc.
    Sunday, June 16, 2013 11:15 AM
  • BAM is a set of 5 databases and also requires SQL Analysis Services. A lot of people prefer to have a separate instance with SQL Analysis configured to server as the location for installing these databases.

    In regards to size, 80 to 100 GB is normally OK. It depends on how much data you wish to keep w.r.t the trends and analysis data. There are archive jobs that help you keep this database growth in check.

    Regards.

    • Marked as answer by Pengzhen Song Friday, June 21, 2013 10:42 AM
    Sunday, June 16, 2013 2:58 PM