Ops DB free space low
Above is the alert description: percent free space is 40% in System Centre Essentials SP1. I would like to enlarge the database, how can i do that? I know the option of grooming in the administrative pane but grooming is set at 7 days, i would like to keep that. Maybe enlarging the database with 10 gb is a solution. The sql database is on the server as System Centre itself. freddie
April 1st, 2009 5:33pm
Hi Freddie,Are you running SQL Server Express or full SQL?Thanks,Lee
Free Windows Admin Tool Kit Click here and download it now
April 1st, 2009 10:26pm
It is, i believe, the full version with management studio etc. Version 2005. Version SQL Server 9.0.3054 freddie
April 3rd, 2009 9:01am
Hi,If you have verified the SQL edition is full verison, you can try to following steps toenlarge DB initial size:1. Open SQL management console.2. Navigate OpsDW->properties->files. In right pane, you can enlarge DB size.HTH.Jie-Feng Ren - MSFT
Free Windows Admin Tool Kit Click here and download it now
April 7th, 2009 12:38pm
The following is what i see where you are talking about: MOM-data data primairy 1000 10% unstricted growth etc (when i want to change the 1000 value it gives me 1.000) MOM log not applicble 500 10% stricted growth Which one to change? freddie
April 7th, 2009 12:59pm
Hi,You can change MOM_DATA to enlarge DB size. HTH.Jie-Feng Ren - MSFT
Free Windows Admin Tool Kit Click here and download it now
April 9th, 2009 5:26am
I have enlarged the number bij MOM data. Changed it to 2.000. Now, a week later i get againt the error that the OPS DB free space low 39.95%. I don't have much extra things outside the standard things that i monitor. freddie
April 27th, 2009 9:28am
I still get the error: Ops db free space is low. How can i handle this? The setting in sqlstudio on Ooperationmanager DW is: MOM_data 20000 The setting is by 10% unlimited growth. I can't see the free space. If the size is at 40% of the free space how can i make this smaller so that theused space is less then 40% or enlarge the free space of the drive?or a database? freddie
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2009 11:04am
I am getting the same error using the SQL Express Edition. How would I use the Management Studio Express to set these changes?
August 14th, 2009 11:53pm