I was checking the BizTalk database best practices guide against our Test BizTalk server database and

ran 'DBCC SHOWCONTIG' command

and noticed that few of the BizTalk tables have Scan Density value less than 30%

what in the first place is responsible or cause of a lowered value??

And how do I make sure that it is set back to optimal value once again?

Appreciate any help. Thanks!

• Edited by Annee797 Wednesday, July 15, 2015 7:09 PM

Hi Anee,

Low Scan Density may be because of deadlock is fragmentation of index on BizTalkMsgBox. We ran "DBCC SHOWCONTIG" against the BizTalkMsgBox. According to Microsoft recommendation , if the Scan Density value that is returned by the DBCC SHOWCONTIG statement is less than 30 percent, the BizTalk Server indexes can be rebuilt during downtime. It  suggests that that BizTalk Message Box is highly defragmented. Hence theres a need to re-build index for the BizTalk Message Box database.

Reference

https://support.microsoft.com/en-us/kb/917845

http://www.enkaytech.com/biz-talk/power-bi/2/

Thanks

Abhishek

• Proposed as answer by Abhishek0127[Abhishek kumar]MVP 3 hours 2 minutes ago

Hi Anee,

Low Scan Density may be because of deadlock is fragmentation of index on BizTalkMsgBox. We ran "DBCC SHOWCONTIG" against the BizTalkMsgBox. According to Microsoft recommendation , if the Scan Density value that is returned by the DBCC SHOWCONTIG statement is less than 30 percent, the BizTalk Server indexes can be rebuilt during downtime. It  suggests that that BizTalk Message Box is highly defragmented. Hence theres a need to re-build index for the BizTalk Message Box database.

Reference

https://support.microsoft.com/en-us/kb/917845

http://www.enkaytech.com/biz-talk/power-bi/2/

Thanks

Abhishek

• Proposed as answer by Abhishek0127[Abhishek kumar]MVP Monday, July 20, 2015 4:02 AM

Hi Anee,

Low Scan Density may be because of deadlock is fragmentation of index on BizTalkMsgBox. We ran "DBCC SHOWCONTIG" against the BizTalkMsgBox. According to Microsoft recommendation , if the Scan Density value that is returned by the DBCC SHOWCONTIG statement is less than 30 percent, the BizTalk Server indexes can be rebuilt during downtime. It  suggests that that BizTalk Message Box is highly defragmented. Hence theres a need to re-build index for the BizTalk Message Box database.

Reference

https://support.microsoft.com/en-us/kb/917845

http://www.enkaytech.com/biz-talk/power-bi/2/

Thanks

Abhishek

• Proposed as answer by Abhishek0127[Abhishek kumar]MVP Monday, July 20, 2015 4:02 AM
• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Thursday, July 23, 2015 1:45 AM