Just about every 24 hours my SCE server basically locks up. I have SCE installed on one machine with SQL Express. Once the problem occurs I can't even log on to the machine so I have to reset it. Once reset I get a number of alerts: Alert: Root Management Server Unavailable. Source: nwms.chacon.local Path: nwms.chacon.local Last modified by: System Last modified time: 10/9/2008 10:24:03 AM Alert description: The root management server (Healthservice) has stopped heartbeating soon after 10/8/2008 10:53:34 AM. This adversely affects all availability calculation for the entire management group. ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Alert: Data Warehouse failed to enumerate database components to be deployed Source: nwms.chacon.local Path: nwms.chacon.local Last modified by: System Last modified time: 10/9/2008 10:26:20 AM Alert description: Data Warehouse failed to enumerate database components to be deployed. Failed to enumerate Data Warehouse components for deployment. The operation will be retried. Exception 'SqlException': Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component Here is the entry I get in the ops manger event logs as the error occurs: Event Type:ErrorEvent Source:Health Service ESE StoreEvent Category:Transaction Manager Event ID:623Date:10/8/2008Time:10:53:43 AMUser:N/AComputer:NWMSDescription:HealthService (1648) The version store for this instance (0) has reached its maximum size of 80Mb. It is likely that a long-running transaction is preventing cleanup of the version store and causing it to build up in size. Updates will be rejected until the long-running transaction has been completely committed or rolled back. Possible long-running transaction: SessionId: 0x08A10280 Session-context: 0x00000000 Session-context ThreadId: 0x00000F88 Cleanup: 1 For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Can anyone help me with this? I'm about to do a full uninstall and reinstall if I can't fix this.

Hi,From this error:HealthService (1648) The version store for this instance (0) has reached its maximum size of 80Mb. It is likely that a long-running transaction is preventing cleanup of the version store and causing it to build up in size. Updates will be rejected until the long-running transaction has been completely committed or rolled back. It indicated that the ESE store is full, I'd like to suggest you clear the Health Service cache:1. Stop Health Service on your SCE server.2. Open a windows explorer, navigate to %programfiles%\system center essentials 2007\health service state\health service store\3. Delete all the files under this folder, then restart the health service.--------------------Regards,Eric Zhang

Is this size limit accurate? Ours is currently 374MB but I have not received Event ID 623. What problem I do have isEvent ID 31569 Exception 'SqlException': Timeout expired and is supposed to be fixed by HotFixhttp://support.microsoft.com/kb/954643. I've applied this and still get the timeouts.So maybe this 80MB limit is my problem?Can someone please verify?thanks

If you want to know the maximum of Health service cache size, Let see this registry key: HKLM\SYSTEM\CurrentControlSet\Services\HealthService\Parameters\Persistence Cache Maximum and I think this article my be help you: http://blogs.technet.com/b/mgoedtel/archive/2010/08/24/performance-optimizations-for-operations-manager-2007-r2.aspxThank you, Wiwat