Can we use Index Rebuild Maintenance task to defrag indexes for BizTalk Databases?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Can we use Index Rebuild Maintenance task to defrag indexes for BizTalk Databases?

Viewing 1 reply thread
  • Author
    Posts
    • August 27, 2009 at 5:09 PM #23135
      community-content

        Hi,

        from the link http://msdn.microsoft.com/en-us/library/ee308910%28BTS.10%29.aspx

        BizTalk Server does not support defragmenting indexes. “DBCC
        INDEXDEFRAG” and “ALTER INDEX … REORGANIZE …” are not supported since
        they use page locking, which can cause blocking and deadlocks with
        BizTalk Server. BizTalk Server does support database index rebuilds
        (“DBCC DBREINDEX” and “ALTER INDEX … REBUILD …”), but they should only
        be done during maintenance windows when BizTalk Server is not
        processing data. Index rebuilds while BizTalk Server is processing data
        are not supported.

         

        So my question is Can we use Index Rebuild Maintenance task to defrag indexes for BizTalk Databases?

        thanks

      • September 17, 2009 at 5:31 PM #23272
        community-content

          could you advice plz…

          • September 23, 2009 at 5:10 AM #23295
            community-content

              Re-indexing should be done only during down times, and the bts_rebuildindexes stored procedure is the only supported way to rebuild BizTalk indexes.

              Running the bts_rebuildindexes is only supported during down-time, meaning no BizTalk Server processes should be running or any isolated adapters running.

               

              Manuel Stern

        • Author
          Posts
        Viewing 1 reply thread
        • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.