It looks like I'm getting erros similar to the one below in my R2 environment. It looks like running dwdatarp shows that most of the storage is being used by the event data set. Can I just change the max age on that set and wait for StandardDataSetMaintenance to run again? Failed to store data in the Data Warehouse. Exception 'SqlException': Sql execution failed. Error 777971002, Level 17, State 1, Procedure AlertProcessStaging, Line 675, Message: Sql execution failed. Error 1105, Level 17, State 2, Procedure AlertProcessStaging, Line 185, Message: Could not allocate space for object 'Alert.AlertStage2Process' in database 'OperationsManagerDW_staging' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.StandardDataSetMaintenance Instance name: Alert data set Instance ID: {B286B862-C730-ADB7-C4B1-14D66438D40D} Management group: MYDOMAIN ---- Failed to store data in the Data Warehouse. The operation will be retried. Exception 'SqlException': Could not allocate space for object 'Perf.PerformanceStage'.'PK__PerformanceStage__7518DCF6' in database 'OperationsManagerDW_staging' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectPerformanceData Instance name: myrms.mydomain.com Instance ID: {74A08A3A-7C0C-9414-9152-B05B401201DB} Management group: MYDOMAIN

In addition to changing the max age, I would also suggest adding another file to the filegroup.

I also would like to share the following information regarding this issue: Could not allocate space for object: http://social.technet.microsoft.com/Forums/en-US/systemcenter/thread/02fe13a8-cf50-45d2-a3f3-a1133090b9b7/ Estimating Database Sizes for OpsMgr 2007: http://ops-mgr.spaces.live.com/blog/cns!3D3B8489FCAA9B51!171.entry?sa=240025836 Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.