SCOM: How to Increase RTCLOCAL;msdb SQL Database sizes

Author: Jeff McBride

Description:

The following SCOM Alert states a database is running out of space on a Lync server.  The variables that may be different for each alert/server will be the File Group, Database and SQL Instance.

Alert: File group is running out of space
Source: PRIMARY
Path: FEServerName.LyncLead.com;RTCLOCAL;msdb
Last modified by: System

Last modified time: 6/21/2012 9:11:38 AM Alert description: The file group “PRIMARY”  for the database “msdb” in SQL instance “RTCLOCAL” on computer “FEServerName.LyncLead.com” is running out of space. See knowledge section for more details.

1.       Open Microsoft SQL Server Management Studio locally to the server servers or remotely from your machine/tools server.

  • Connect to the server and SQL Instance listed in the alert
  • Use the format: ServernameFQDN\SQLInstance as show below

image001

*NOTE:  If you’re unable to connect you will need to create a new Firewall rule on the listed server and open the following ports:

I.        TCP:  1434, 51255

a.       Name as SQLBrowser  or whatever strikes your fancy

image002

II.      UDP:  1433

a.       Name as SQLBrowser2  to be very creative.

image003

 

2.       Go to the properties of the database noted in the alert

3.       Select Files in the menu pane

4.       Take note of the Filegroup listed in the alert and its Initial Size (MB) setting

image004

5.       Increase the Initial Size (MB) by doubling the amount that’s currently listed

  • 13MB would become 26MB (This KB felt like rounding to 30MB).

image005

6.       Click OK

Leave a Reply