databse size

• 2012년 4월 19일 목요일 오후 8:31

   

   
  

  0

  Hello,

  I have 7,000 Clients, the grooming

  select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs
  join classschemas cs
  on cs.cs_classID = wcs.wcs_classID
  where cs.cs_tablename = 'SC_SampledNumericDataFact_Table'
  and wcs.wcs_mustbegroomed = 1
  select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs
  join classschemas cs
  on cs.cs_classID = wcs.wcs_classID
  where cs.cs_tablename = 'SC_AlertFact_Table'
  and wcs.wcs_mustbegroomed = 1
  select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs
  join classschemas cs
  on cs.cs_classID = wcs.wcs_classID
  where cs.cs_tablename = 'SC_EventParameterFact_Table'
  and wcs.wcs_mustbegroomed = 1
  select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs
  join classschemas cs
  on cs.cs_classID = wcs.wcs_classID
  where cs.cs_tablename = 'SC_AlertToEventFact_Table'
  and wcs.wcs_mustbegroomed = 1
  select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs
  join classschemas cs
  on cs.cs_classID = wcs.wcs_classID
  where cs.cs_tablename = 'SC_EventFact_Table'
  and wcs.wcs_mustbegroomed = 1
  select cs.cs_tablename 'Table Name', wcs.wcs_groomdays 'Groom Days' from warehouseclassschema wcs
  join classschemas cs
  on cs.cs_classID = wcs.wcs_classID
  where cs.cs_tablename = 'SC_AlertHistoryFact_Table'
  and wcs.wcs_mustbegroomed = 1

  Value 60 for all items...

  but the database systemcenterreporting (RedData.mdf) is 550000 MB +!!!

  from http://blogs.technet.com/b/fcsnerds/archive/2008/09/25/fcs-with-mom-2005-database-guidance.aspx

  I should never reach this size, what to do? what to look ?

  I have Microsoft SQL Server Enterprise Edition.

  Anyway to clear the old entries to get space .... the SCDWGroomJob does not seem to clear enough , I could chnage the number of days, but in the meantime I need to clear the space straight.

  Is it possible to start fresh from scratch as most of the dat are old?

  Thanks,
  DOm

  ---

  System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

  
  
  
  

  • 편집됨 Felyjos 2012년 4월 19일 목요일 오후 8:35
  • 편집됨 Felyjos 2012년 4월 19일 목요일 오후 8:37
  • 편집됨 Felyjos 2012년 4월 19일 목요일 오후 8:38
  •  
  • 응답
  • 인용