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