Forefront Client Security Sizing.
Hello, 650 servers Onepoint: - Data 2,000 - Log 10,000 SystemCenterReporting: - Data 85,000 - Log 18,000 this seems really far from the guide... OnePoint: - Data 2,000 - Log 1/3 of data which should be 700 but even with less than 5,000 it is full each time... the maintenanceplan runs... SystemCenterReporting: looks correct for the Data if we consider 395 days but I have 60 days only !!! and the log should be 3,500 if OnePoint was 7000 but as it is 10,000 should it be 50,000... (: http://blogs.technet.com/b/fcsnerds/archive/2008/09/25/fcs-with-mom-2005-database-guidance.aspx and it is full every other day !!! especially I have a 60 days grooming set to try to minimize the size!!! 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 Any idea? something does not seem right at least for the log files!!! Thanks, Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
July 5th, 2011 6:10pm

Hello, Still the same numbers 650 servers Onepoint: - Data 2,000 - Log 20,000 otherwise it is failing each night!!! SystemCenterReporting: - Data 85,000 - Log 150,000 SCDWGroomJob is failing each night this seems really far from the guide... and still growing Where to look for pattern, clue? Thanks, DOm System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager
Free Windows Admin Tool Kit Click here and download it now
July 12th, 2011 6:10pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics