SAP Knowledge Base Article - Preview

2430136 - MSSQL: How to cleanup 0MSS_C08* infocubes

Symptom

You need to reduce the number of records or cleanup the data cubes 0MSS_C08*:

  • 0MSS_C08D MSS: Table and Index Sizes (Daily).
  • 0MSS_C08H MSS: Table and Index Sizes (Hourly).
  • 0MSS_C08M MSS: Table and Index Sizes (Monthly).

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.


Read more...

Environment

  • SAP Solution Manager 7.1 and higher;
  • MS SQL Server 2008 (R2) and higher;

Product

SAP Solution Manager 7.1 ; SAP Solution Manager 7.2

Keywords

0MSS, Solman, housekeeping, house keeping, cleaning, MSS, SQL Server, Solution Manager, E2E BI, E2E_HK_AGGREGATE_MDX, 0MSS_C08D, 0MSS_C08H, 0MSS_C08M, SMD_HK_AGGREGATE_MDX, CL_SMD_AGGREGATE_MDX, CONVT_OVERFLOW, CX_SY_CONVERSION_OVERFLOW, CL_SMD_AGGREGATE_MDX , KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , BW-SYS-DB-MSS , BW on Microsoft SQL Server , SV-SMG-DIA , Diagnostics , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.