none
Public Folder Database grows constantly

    Question

  • Hello!

    We get a strange behaviour of our Exchange 2010 (SP1). The public folder database is growing constantly. It only contains about 5GB of user content and the system folders like OAB. But it's size is now about 130GB with almost no whitespace!

    I have changed the deleted items retention time from 30 to 15 days. The next morning, there where 2 more gigabytes available as whitespace. So I think database maintenance is running fine.

    Currently the database is not growing, but about twice a day there are many logs written.

    I've read http://support.microsoft.com/kb/2621266/en-us, but we don't use journalling or archiving. Also, the problem only occurs in the public folder database, not the mailbox databases.

    Do you know this problem? Is there a way to open the logfiles with a viewer to see which elements are modified in the transaction?

    Or as a last resort, am I able to create a second public folder database and copy all folders to the new database? I think this is not possible in a single server setup, is it?

    Thank you very much!

    Best regards,

    Manuel

    Thursday, October 31, 2013 7:45 AM

All replies

  • I'm currently running an offline defrag. Doesn't seem to help, DB is almost 50GB yet and defrag is only 50% completed. :(
    Thursday, October 31, 2013 1:35 PM
  • Hi,

      • Is the data base dismounted?
      • You need to have some disk space(110% of Database size), for a period of time both the old and new files will exist, as well as a temporary file that eseutil creates
      • Make sure you have circular logging enabled for the public folder database
      • Try to do full backup for public folder database to truncate some unrequired logs


     Related article:

    http://blogs.technet.com/b/exchange/archive/2013/04/18/troubleshooting-rapid-growth-in-databases-and-transaction-log-files-in-exchange-server-2007-and-2010.aspx


    Sidharth Guntoji,Messaging Consultant, ITBigBang (P) Ltd Www.ITBigBang.Com | Hire Us for Messaging Consulting


    Thursday, October 31, 2013 5:19 PM
  • Hi Sidharth,

    thank you for your answer! Yes, the database was dismounted. We backup using DPM every hour, so logfiles will get deleted regularly.

    Over the day it was silent, but the rush began about an hour ago. Over 12GB logs in one hour! But the database did not grow over 1GB. So I assume there is a client which is deleting and uploading all items. I've opened the logfiles in notepad and could see which customer it is. He's using a Mac.

    Strangely, creation or last access time of the elements did not change!

    Maybe I should search for the error in Outlook for Mac ond not on the server? But it's still strange that so much space is taken by the database.

    Thursday, October 31, 2013 5:51 PM
  • Hi,

    Once run this command which may helps to monitor the public folder size change.

      Get-PublicFolderStatistics |fl >c:\publicfolder.txt


    Sidharth Guntoji,Messaging Consultant, ITBigBang (P) Ltd Www.ITBigBang.Com | Hire Us for Messaging Consulting

    Thursday, October 31, 2013 6:24 PM
  • Hi Manuel,

    About this issue, besides Sidharth's suggestion, I recommend you upgrade to Exchange 2010 SP3 RU2 and then see the result. Please download them at here:

    Microsoft Exchange Server 2010 Service Pack 3

    http://www.microsoft.com/en-in/download/details.aspx?id=36768

    Update Rollup 2 For Exchange 2010 SP3

    http://www.microsoft.com/en-in/download/details.aspx?id=39835

    Hope it can solve the problem.

    If the issue persists, please feel free to let me know.

    Best regards,
    Amy


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
    Thanks for helping make community forums a great place.


    Friday, November 01, 2013 7:52 AM
    Moderator
  • Thank you! An update to SP3 is planned, but needs some time to be done because the server is integrated in a control panel.

    I think the one client with the new Mac could cause the problems. How can I see how much requests a user sends?

    I've got

    Get-PublicFolderDatabase | Get-LogonStatistics | where-object {$_.Windows2000Account -like "*customer*"} | fl username,totaloperationcount,currentopenfolders,currentopenmessages

    Is this correct?

    Best regards,

    Manuel

    Friday, November 01, 2013 1:27 PM
  • Hi,

    If you don't want to do a upgrade currently, the best way for troubleshooting the problem is to create a new database and move public folder in it.

    What's more, here are some similar threads for your reference.

    How to free space on Exchange 2010 database wihout affecting retentioned items, just moving users

    http://social.technet.microsoft.com/Forums/exchange/en-US/5a8eff78-491d-4e0f-a331-5340183ebfa7/how-to-free-space-on-exchange-2010-database-wihout-affecting-retentioned-items-just-moving-users?forum=exchange2010

    Reduce Exchange 2010 public folder database size

    http://social.technet.microsoft.com/Forums/exchange/en-US/904d99ca-9e66-4aa6-8747-aadf59b9ef6b/reduce-exchange-2010-public-folder-database-size?forum=exchange2010

    Hope my clarification has been helpful.

    Best regards,
    Amy


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time.
    Thanks for helping make community forums a great place.

    Sunday, November 03, 2013 5:02 AM
    Moderator
  • Correct.   Exchange 2010 SP1 has been out of support for almost a year..

    http://blogs.technet.com/b/rmilne/archive/2013/01/04/end-of-exchange-2010-sp1-support.aspx

    And SP2 rolls out of support on 8th of April 2014

    http://blogs.technet.com/b/rmilne/archive/tags/supportability+dates/

    I would update to SP3 RU2.

    For fixing this, if you have been able to isolate the cause of growth to a single user then do not let them use Outlook etc right now.  Get them to use OWA for the next few days to make sure the situation calms down.  if it is them then its time to see what their machine is doing...


    Cheers,

    Rhoderick

    Microsoft Senior Exchange PFE

    Blog: http://blogs.technet.com/rmilne  Twitter:   LinkedIn:   Facebook:   XING:

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Sunday, November 03, 2013 12:42 PM
  • Hi Amy,

    thank you for your links! But I'm sorry, I don't get it at the moment: I've tried offline defrag with no success. So the next option would be to move the public folders to a new DB. Mailbox moving is no problem, but public folders? I've read that only one public folder DB can exist on a server. So how to create a new DB and move the public folders?

    Upgrade to SP3 is planned for sure, but I'd be happy to reclaim the space in the meantime.

    Best regards,

    Manuel

    Monday, November 04, 2013 7:36 AM
  • You would need to create a new PF database on another mailbox server, and then add replicas of the content (system and user folders).  Once replication has completed, remove the original replica.  Then you can remove the first database. 

    Alternatively, offline defrag that PF store as-is.


    Cheers,

    Rhoderick

    Microsoft Senior Exchange PFE

    Blog: http://blogs.technet.com/rmilne  Twitter:   LinkedIn:   Facebook:   XING:

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Monday, November 04, 2013 12:43 PM
  • One other thing, take a peek here:

    http://blogs.technet.com/b/rmilne/archive/2013/08/20/how-to-check-database-white-space-in-exchange.aspx

    Have you run eseutil /MS to see what's consuming space in the DB ?


    Cheers,

    Rhoderick

    Microsoft Senior Exchange PFE

    Blog: http://blogs.technet.com/rmilne  Twitter:   LinkedIn:   Facebook:   XING:

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Monday, November 04, 2013 12:44 PM
  • Thank you for the link, Rhoderick!

    Unfortunately there is only one server in this organization, so I can't replicate to another server.

    Offline defrag did not help either: It just freed the size of "AvailableNewMailboxSpace", nothing more. Problem is that all public folders and OABs should be not more than 5GB, but are now 133GB and growing...

    Here is the output of eseutil /ms:

    Initiating FILE DUMP mode...
    File Information:
      File Name: ..\Exchange\DB\PuplicFolders.edb
      Volume Name: Data
      File System: NTFS
      Cluster Size: 65536 bytes
      Attribute List Size: 5824 bytes
      Extents Enumerated: 40993
    
             Database: ..\Exchange\DB\PuplicFolders.edb
    
    ******************************** SPACE DUMP ************************************
    *****
    Name                    Type    Owned(MB)     %OfDb  %OfTable    Avail(MB) Avail
    %Tbl
    ================================================================================
    =====
    ..\Exchange\DB\PuplicFo  Db    125540.469   100.00%                  3.469
    
    
      Body-1-B1A45D21        Pri    10730.844     8.55%   100.00%        0.751     0
    .01%
        [Long Values]        LV     10727.219     8.54%    99.97%        0.313     0
    .00%
      Body-1-B1A48148        Pri     1587.907     1.26%   100.00%        0.657     0
    .04%
        [Long Values]        LV      1585.532     1.26%    99.85%        0.407     0
    .03%
      Body-1-B1AF471E        Pri    62516.969    49.80%   100.00%        0.876     0
    .00%
        [Long Values]        LV     62339.094    49.66%    99.72%        0.251     0
    .00%
      Body-1-B21769FE        Pri    38605.594    30.75%   100.00%        1.063     0
    .00%
        [Long Values]        LV     38488.219    30.66%    99.70%        0.469     0
    .00%
      Body-1-B286E99F        Pri     3137.126     2.50%   100.00%        1.313     0
    .04%
        [Long Values]        LV      3095.876     2.47%    98.69%        0.594     0
    .02%
      Body-1-B2F47D3F        Pri     1286.407     1.02%   100.00%        1.000     0
    .08%
        [Long Values]        LV      1275.376     1.02%    99.14%        0.313     0
    .02%
    Note: Some small tables/indices were not printed (use /v option to see those sma
    ller than 0.5% of the database).
    --------------------------------------------------------------------------------
    -----
    
        Enumerated 11643 Tables ( 1560 Internal Trees, 100 Long Value Trees, 4898 Se
    condary Indices )
    
        Pages 4017295 ( 3993222 Used (99.4%), 24073 Available (0.6%) )

    I can't see massive space taken by somewhat specific.

    As a last resort, is there a PowerShell script which exports all folders (including NON_IPM_SUBTREE) to a PST, create a new DB and import it thereafter?

    Monday, November 04, 2013 3:00 PM