Reduce the size of logging database

To reduce the size of the logging database or to purge the old data from the logging database we can these steps:

By Default the system retains 14 days of Usage data in this database. You need to decrease value of the retention days by the following PowerShell Command:

Set-SPUsageDefinition –Identity "Event Selection" -DaysRetained days

Example:

Set-SPUsageDefinition –Identity “Page Requests" -DaysRetained 3

You can get values of retention days by the following command

Get-spusagedefinition

After that we need to run the two timer jobs to clean the old data, Go to Job Definitions and Run the following Jobs:

• Microsoft SharePoint Foundation Usage Data Import
• Microsoft SharePoint Foundation Usage Data Processing

Once the timer jobs is run you can check and confirm database has released the space.

SharePoint 2010 Sandbox Form Post limitation

When try to use form created in sandbox solution. I found error when post data more than 128 KB. It is one limitation of more limitations in sandbox solutions.

We need to increase size to increase this limit requestlengthdiskthreshold.

Sandbox processes use SPUCHostService.exe/SPUCHostService.exe. which has extra web.config (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\UserCode\web.config), When you updated requestlengthdiskthreshold value in this web.config problem will be solved. But this solution would not work on a hosting provider. There would be little chance they would change their UserCode settings for me.