none
FIM Sync DB Maintenance RRS feed

  • Question

  • Hi,

    In a little over 3 months our FIM Sync database has grown to over 30GB.

    At the SQL database level, there do not appear to be any default jobs to archive/purge data. Is there anything in FIM Sync itself - other than clearing the Run Profile history?

    Do FIM SQL backups do anything?

    I assume the FIM Sync database is just expected to grow over time?

    Thanks,

    SK

    Thursday, September 3, 2015 3:07 AM

All replies

  • Unfortunately there is a piece of information missing.
    What was the size 3 months ago, so to see if the growth is abnormal.  And what is the population of objects being managed; users and groups.

    One thing to do is to purge Transaction_log table


    Nosh Mernacaj, Identity Management Specialist

    Thursday, September 3, 2015 1:35 PM
  • Sure, we started off with about 2GB.

    MV has 100 users, 25 Groups, 1-5 delta transactions per day.

    Friday, September 4, 2015 1:59 AM
  • this is not right. The next thing to check is what table is growing. I really think is transaction logs. Thete is not mich you can do on FIM side - to answer your original question.

    Nosh Mernacaj, Identity Management Specialist

    Friday, September 4, 2015 11:27 AM
  • thank you, you mention purging the Transaction_log table...not being a SQL person, is this something easily done via a script? stored procedure? is there anything in the out of the box FIM Sync database stored procedures section?

    where can I read up more about it and learn? thank you

    Friday, September 4, 2015 11:04 PM
  • Hello Shim.

    The first question is: how are you backing up your environment?

    Transaction log can be easily cleaned if you have full backups made straight from SQL (for example by job or manually with Management Studio). If you are backing up using other tool or by creating a snapshot of SQL VM, the best option would be to change Recovery Model option of FIMSyncService to Basic instead of Full.

    Then you can shrink log file. For example using the following: Shrink a File


    If you found my post helpful, please give it a Helpful vote. If it answered your question, remember to mark it as an Answer.

    Tuesday, September 8, 2015 7:22 AM
  • Shim,

    How often are you executing Run Profiles?  Have you cleared any of the Run Profile History during this time?  That is also a common reason for database growth.

    Take a look at the following articles for some additional information regarding cleaning up Run Profile History:

    http://social.technet.microsoft.com/wiki/contents/articles/7034.fim-reference-how-to-clear-the-run-history.aspx

    http://social.technet.microsoft.com/wiki/contents/articles/2096.how-to-use-powershell-to-delete-the-run-history-based-on-a-specific-date.aspx

    Hope that helps!

    -Ryan

    Tuesday, September 8, 2015 6:55 PM
  • Ryan, he did already mention the run history

    "anything in FIM Sync itself - other than clearing the Run Profile history?"


    Nosh Mernacaj, Identity Management Specialist

    Tuesday, September 8, 2015 7:41 PM
  • let me do some investigations on our side and get back to you - thank you all for your help (as usual, great guys & girls on these forums!)
    Wednesday, September 9, 2015 2:51 AM