After you install SP1 for Operations Manager 2007..... what's next?
1. Check the Operations Manager event logs.... look for any major issues.
2. Inspect all the services (SDK and HealthService) on all OpsMgr servers - make sure they are running.
3. Check the DB version to make sure it was upgraded successfully.
4. UPDATE YOUR MANAGEMENT PACKS. The core system MP's will update to 6.0.6278.0 automatically. However - the optional MP's will not. You must update these manually. The most current version for SP1 will be on the SP1 media, in the \ManagementPacks directory. Also - new MP's will start releasing to the OpsMgr catalog. Many of the older MP's are not fully compatible with SP1, and need to be updated where applicable.
5. UPDATE YOUR AGENTS. There is a known issue with older version agents reporting to a SP1 management server: http://support.microsoft.com/kb/941811/en-us If you were running RTM - yours agents can be upgraded in Pending Management. If you were running RC-SP1 - you can update your agents by viewing "Agent Managed", sort by "Version" and then multi-select agents, and choose "Repair". This is similar to approving a Pending Management request. Typically you can do 200 agents at a time.... depending on your environment.