locked
APP-V Usage data clean up RRS feed

  • Question

  • Hello,

    I'm designing an App-V full infrastructure. Now i've come accross some issues with the database management. There are two settings which have influence my design. 

    • Database size
    • Keep usage for (months)

    Best practise recommends not putting a higher value than 4GB into the first setting. (http://technet.microsoft.com/en-us/library/cc843727.aspx)

    However, license management wants to keep usage data for 1 year. A quick calculation using the formula in the Sizing guide will tell me 45GB of usage will be saved every year. My DBA guys tell me this is not a problem. 

    So can i skip best practise and just configure no size limit? Or is there a way to move usage logging to a different db after several months. Is there a table/db design which tells me how to do this?

    And is there a way to clean the message_log table, i've already configured the servers to log only errors. So as little as data possible is already logged.

    Kind regards

     

    Friday, May 13, 2011 7:36 AM

Answers

  • If you want to script the archiving and alternative storage of this information it can be found in the MESSAGE_LOG and APPLICATION_USAGE table. In order to ensure the information does not get purged using the default App-V SQL jobs, you will need to disable "Enforce Size Limit."
    Steve Thomas, SSEE, Microsoft
    App-V/MED-V/SCVMM/SCCM/AppCompat
    http://madvirtualizer.wordpress.com/
    The App-V Team blog: http://blogs.technet.com/appv/
    The MED-V Team Blog: http://blogs.technet.com/medv
    The SCVMM Team blog: http://blogs.technet.com/scvmm/

    “This posting is provided "AS IS" with no warranties, and confers no rights. User assumes all risks.”
    • Marked as answer by Luc Raeskin Wednesday, May 18, 2011 6:15 AM
    Monday, May 16, 2011 7:53 PM
  • Hello,

    DB-schema can be purchased from Tmurgent;

    http://www.tmurgent.com/Books/default.aspx

    If your business requirements do require you to maintain that large of a dataset you should go ahead and test it before you put it into production. . App-V supports (as per the documentation you posted) to only be limited by available disk-space incase of need. 


    /Znack
    • Proposed as answer by znack Tuesday, May 17, 2011 11:11 AM
    • Marked as answer by Luc Raeskin Wednesday, May 18, 2011 6:15 AM
    Sunday, May 15, 2011 8:58 PM

All replies

  • Hello,

    DB-schema can be purchased from Tmurgent;

    http://www.tmurgent.com/Books/default.aspx

    If your business requirements do require you to maintain that large of a dataset you should go ahead and test it before you put it into production. . App-V supports (as per the documentation you posted) to only be limited by available disk-space incase of need. 


    /Znack
    • Proposed as answer by znack Tuesday, May 17, 2011 11:11 AM
    • Marked as answer by Luc Raeskin Wednesday, May 18, 2011 6:15 AM
    Sunday, May 15, 2011 8:58 PM
  • If you want to script the archiving and alternative storage of this information it can be found in the MESSAGE_LOG and APPLICATION_USAGE table. In order to ensure the information does not get purged using the default App-V SQL jobs, you will need to disable "Enforce Size Limit."
    Steve Thomas, SSEE, Microsoft
    App-V/MED-V/SCVMM/SCCM/AppCompat
    http://madvirtualizer.wordpress.com/
    The App-V Team blog: http://blogs.technet.com/appv/
    The MED-V Team Blog: http://blogs.technet.com/medv
    The SCVMM Team blog: http://blogs.technet.com/scvmm/

    “This posting is provided "AS IS" with no warranties, and confers no rights. User assumes all risks.”
    • Marked as answer by Luc Raeskin Wednesday, May 18, 2011 6:15 AM
    Monday, May 16, 2011 7:53 PM
  • You can run "truncate table message_log" however this will remove all the log data.

    If you want to delete all prior to a certain date you can do a: delete from message_log where msg_time<'2011-01-01' for example to remove everything earlier than 2011.

    If thats ok use a maintenance plan or sql job to run it on a regular basis.


    • Edited by kilimanj99 Monday, May 23, 2011 6:17 PM forgot quotes
    Monday, May 23, 2011 6:16 PM