Check Database Size

There is a standard SQL report that shows how much space a database is using. In SQL Server Management Studio for SQL Server 2008 R2 and newer, right-click on the database you are interested in and select Reports->Standard Reports->Disk Usage.

There is a good description of this report, including information about how to resize a Operations Manager database in the SCOMfaq.ch blog: http://blog.scomfaq.ch/2012/06/26/scom-check-size-of-databases-sql-standard-reports/

The broken Operations Manager Shell

I have a management server with the Operations Manager Console installed. When I tried to start the Operations Manager Shell it failed with the following errormessage:
Import-Module : The specified module ‘OperationsManager’ was not loaded because
no valid module file was found in any module directory.
At line:1 char:14
+ Import-Module <<<< OperationsManager; .\OperationsManager\Functions.ps1; .\O perationsManager\Startup.ps1
     + CategoryInfo : ResourceUnavailable: (OperationsManager:String)
        [Import-Module], FileNotFoundException
       + FullyQualifiedErrorId : Modules_ModuleNotFound,Microsoft.PowerShell.Comm
        ands.ImportModuleCommand

The term ‘Start-OperationsManagerClientShell’ is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At C:\Program Files\System Center 2012\Operations Manager\Powershell\OperationsManager\Startup.ps1:26 char:35
+ Start-OperationsManagerClientShell <<<< -ManagementServerName: “” -PersistConnection: $true -Interactive: $true;
         + CategoryInfo : ObjectNotFound: (Start-OperationsManagerClientShell:String) [], CommandNotFoundException
         + FullyQualifiedErrorId : CommandNotFoundException

The reason for this was that the path to “C:\Program Files\System Center 2012\Operations Manager\Powershell\” was missing in the envorinmental variable PSModulePath. Once completed and logged out and back in to the system everything worked as espected.

Event ID: 29106 on RMS Server after upgrade to CU5

After an upgrade of the RMS from SCOM 2007 R2 RTM to SCOM 2007 R2 CU5 EventID 29106 started to appear in the OperationsManager EventLog every 5-15 minutes. The solution was to flush the HealtService.
1. Stop the System Center Management Service.
2. Rename the folder “Health Service State” in C:\Program Files\System Center Operations Manager 2007\.
3. Start the System Center Management Service.

References: http://qa.social.technet.microsoft.com/Forums/en/operationsmanagergeneral/thread/084d2917-f5be-44d6-8286-e4fe4cc8dd7d