Hi Andy,
Did you mean that the SCE console crashes once a day? Is it a stand-alone console or the console on SCE server? Is there any regular interval or operation? What is the error message shown when it crashes?
Also, please run the Event Viewer and check if any error message was logged in Operations Manager events when the crash happens.
As a general suggestion, try the following KB to see if it helps:
The Root Management Server (RMS) of System Center Operations Manager 2007 Service Pack 1 or Essentials 2007 Service Pack 1 becomes unstable or unusable if a management pack is imported
http://support.microsoft.com/kb/951526/en-us
Thanks,
Yog Li - MSFT