none
Alert-LOG Db Growth for BizTalkMgmtDb2010 RRS feed

  • Question

  • Can any one please suggest what should be Microsoft recommended Default settings for optimizing BizTalkMgmtDb2010?

    We used MBV report & below is the details of alert & resolution as per MVB report--

    Alert-LOG Db Growth for BizTalkMgmtDb2010

    Resolotion as per MVB-Not recomended to use percentage (Current =10%,Def=10%) - Recommended for this Db=10240 KB ?!

     
    Wednesday, November 19, 2014 3:14 PM

Answers

  • It's recommending that you change the AutoGrowth from a percentage to a fixed amount.  In this case 10% to 10MB.

    This particular rule is based on general SQL guidance and is considered a better practice than the default.

    • Proposed as answer by Mohan Raj Aryal Wednesday, November 19, 2014 11:24 PM
    • Marked as answer by Angie Xu Wednesday, November 26, 2014 2:43 AM
    Wednesday, November 19, 2014 4:23 PM
    Moderator

All replies

  • It's recommending that you change the AutoGrowth from a percentage to a fixed amount.  In this case 10% to 10MB.

    This particular rule is based on general SQL guidance and is considered a better practice than the default.

    • Proposed as answer by Mohan Raj Aryal Wednesday, November 19, 2014 11:24 PM
    • Marked as answer by Angie Xu Wednesday, November 26, 2014 2:43 AM
    Wednesday, November 19, 2014 4:23 PM
    Moderator
  • Both way it will work ,generally  SQL server Admin gives auto growth of SQL  server files  (MDF LDF) on percentage basis or keep it default at 10 % growth .

    Now coming to Biz Talk ,as BizTalk databases are transactional ,Microsoft recommend to have a auto growth fixed like db growth =10240

    Hope this answer your question

    Thanks

    Abhishek

    Wednesday, November 19, 2014 6:27 PM
  • I'd recommend to run Message Box Viewer, it outputs you the whole list of recommendations for your environment. Recommendations are pretty detailed and thorough.

    Leonid Ganeline [BizTalk MVP]

    Wednesday, November 19, 2014 11:15 PM
    Moderator