none
databse size

    질문

  • 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:38
    2012년 4월 19일 목요일 오후 8:31

답변

  • Hi,

    Thank you for the post.

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

    It seems that SCDWGroomJob does not work after Data Retention change. Please run Appendix script(How to shrink large Databases--SystemCenterReporting DB) in the blog you posted instead of running SCDWGroomJob. Then check the systemcenterreporting DB size(Space Available) and you also could run shrink file task via SQL Management console.

    If there are more inquiries on this issue, please feel free to let us know.

    Regards


    Rick Tan

    TechNet Community Support

    2012년 4월 20일 금요일 오전 8:57

모든 응답

  • Hi,

    Thank you for the post.

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

    It seems that SCDWGroomJob does not work after Data Retention change. Please run Appendix script(How to shrink large Databases--SystemCenterReporting DB) in the blog you posted instead of running SCDWGroomJob. Then check the systemcenterreporting DB size(Space Available) and you also could run shrink file task via SQL Management console.

    If there are more inquiries on this issue, please feel free to let us know.

    Regards


    Rick Tan

    TechNet Community Support

    2012년 4월 20일 금요일 오전 8:57
  • Hi Rick,

    running it now

    Thanks,

    Dom


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

    2012년 4월 20일 금요일 오후 7:05