WSS_Logging database size

Question

Our sharepoint server 2010 WSS_Logging database is about 100GB and counting ... (Farm DB ~1TB / ~100 000 pages viewed per day / ~5000 unique users per days)

I've reduced

• retention and logging levels for all services (through the central sharepoint admin for logging files) to 6 days
• Logging/Usage consolidation to 6 days (through powershell)

I assume this is usage data collection which take the more place, but these data are also used for Web Analytics

Is there any scenario for "large" sharepoint farm & usage data management ? I can't find reference/white paper on this topic.

Answer 1

These guidance posts may be helpful as scenarios can vary -

• 5 Best Practices to Configure Diagnostic Logging with PowerShell Commands
• Best practices for operational excellence
• Best practices for capacity management

UPDATE: Usage logging databases require ongoing maintenance. You can plan on how it's going to be used by selecting the tracing variables and other parameters and also by periodic clean-up tasks (archiving) using PowerShell or other utilities. There's a Sharepoint 2010 Capacity Planning and Sizing Tool that can be helpful in gauging your deployment.