Narendra, do you mean that you only have 4 GB of free space in the OperationsManager database? The database needs at least 40% of free space, preferable 50% for the grooming jobs. More information can be found in the following blog post: http://blogs.technet.com/b/kevinholman/archive/2013/10/03/opsmgr-2012-grooming-deep-dive-in-the-operationsmanager-database.aspx
This could explain why your database is so huge. According to the official sizing tool (http://www.microsoft.com/en-us/download/details.aspx?id=23016), your databse should have a size of about 20,44 GB and your datawarehouse 605,56. Besides the localizedtext-issue, there is also another issue that is described in the following blog post: http://blogs.technet.com/b/kevinholman/archive/2009/12/21/tuning-tip-do-you-have-monitors-constantly-flip-flopping.aspx . Best regards, David Biot On Wed, Jan 21, 2015 at 12:23 PM, Henrik Andersen <[email protected]> wrote: > Which version of SQL Server are you on? > > For SQL Server 2008 please visit > https://msdn.microsoft.com/en-us/library/ms189035.aspx > > /Henrik > > -----Oprindelig meddelelse----- > Fra: [email protected] [mailto:[email protected]] > På vegne af Narendra Bathula > Sendt: 21. januar 2015 12:07 > Til: [email protected] > Emne: [msmom] scom 2007 R2 db size is huge > > Hi All, > > I am running with scom 2007 R2 and my operationsmanager database size is > 140GB occupied. i am having only 850 server under monitoring. How to > reduce this size..? > I believe is huge size that scom DB is using. I have tried Kevin holman > localised text script and got 4gb size freed which is showing in internal > database free space. The free space is not showing in total drive space. > it is showing in only internal database free space. > > How to make some free space in logical drive where database is hosted. > Please suggest me how to get some free space on drive. Thank you. > > > Thanks & Regards, > > Narendra > > > ::DISCLAIMER:: > > ---------------------------------------------------------------------------------------------------------------------------------------------------- > > The contents of this e-mail and any attachment(s) are confidential and > intended for the named recipient(s) only. > E-mail transmission is not guaranteed to be secure or error-free as > information could be intercepted, corrupted, lost, destroyed, arrive late > or incomplete, or may contain viruses in transmission. The e mail and its > contents (with or without referred errors) shall therefore not attach any > liability on the originator or HCL or its affiliates. > Views or opinions, if any, presented in this email are solely those of the > author and may not necessarily reflect the views or opinions of HCL or its > affiliates. Any form of reproduction, dissemination, copying, disclosure, > modification, distribution and / or publication of this message without the > prior written consent of authorized representative of HCL is strictly > prohibited. If you have received this email in error please delete it and > notify the sender immediately. > Before opening any email and/or attachments, please check them for viruses > and other defects. > > > ---------------------------------------------------------------------------------------------------------------------------------------------------- > > > > > > > > > >
