none
scom 2012

    Question

  •  

     Recently i am facing with my sql disk is getting full , The operations manager datawarehouse is growing and we tried the shrinking of log files , again the disk is getting full within 30 min.

    then have created the space around 50 GB on  sql disk , the disk getting full within 30  min .

    run the DWDatarp , found that the configuration data set  showing the 99% of the disk utilization .

    I checked with another Scom server , configuration data set  showing only  10 % of the disk utilization

    Dataset name                   Aggregation name     Max Age     Current Size, Kb
    ------------------------------ -------------------- ------- --------------------
    Alert data set                 Raw data                  10        17,512 (  0%)
    Client Monitoring data set     Raw data                  30             0 (  0%)
    Client Monitoring data set     Daily aggregations       400            32 (  0%)
    Configuration dataset          Raw data                  30   289,485,560 ( 98%)
    Event data set                 Raw data                  10     1,731,888 (  1%)
    Microsoft.Exchange.2010.Dataset.AlertImpact Raw data                   7             0 (  0%)
    Microsoft.Exchange.2010.Dataset.AlertImpact Hourly aggregations        3             0 (  0%)
    Microsoft.Exchange.2010.Dataset.AlertImpact Daily aggregations       182             0 (  0%)
    Microsoft.Exchange.2010.Reports.Dataset.Availability Raw data                 400            16 (  0%)
    Microsoft.Exchange.2010.Reports.Dataset.Availability Daily aggregations       400             0 (  0%)
    Microsoft.Exchange.2010.Reports.Dataset.TenantMapping Raw data                   7             0 (  0%)
    Microsoft.Exchange.2010.Reports.Dataset.TenantMapping Daily aggregations       400             0 (  0%)
    Microsoft.Exchange.2010.Reports.Transport.ActiveUserMailflowStatistics.Data Raw data                   3            24 (  0%)
    Microsoft.Exchange.2010.Reports.Transport.ActiveUserMailflowStatistics.Data Hourly aggregations        7         1,648 (  0%)
    Microsoft.Exchange.2010.Reports.Transport.ActiveUserMailflowStatistics.Data Daily aggregations       182           480 (  0%)
    Microsoft.Exchange.2010.Reports.Transport.ServerMailflowStatistics.Data Raw data                   7           152 (  0%)
    Microsoft.Exchange.2010.Reports.Transport.ServerMailflowStatistics.Data Hourly aggregations       31            80 (  0%)
    Microsoft.Exchange.2010.Reports.Transport.ServerMailflowStatistics.Data Daily aggregations       182           144 (  0%)
    Microsoft.Windows.Client.Vista.Dataset.ClientPerf Raw data                   7             0 (  0%)
    Microsoft.Windows.Client.Vista.Dataset.ClientPerf Daily aggregations        91             0 (  0%)
    Microsoft.Windows.Client.Vista.Dataset.DiskFailure Raw data                   7             0 (  0%)
    Microsoft.Windows.Client.Vista.Dataset.DiskFailure Daily aggregations       182             0 (  0%)
    Microsoft.Windows.Client.Vista.Dataset.Memory Raw data                   7             0 (  0%)
    Microsoft.Windows.Client.Vista.Dataset.Memory Daily aggregations        91             0 (  0%)
    Microsoft.Windows.Client.Vista.Dataset.ShellPerf Raw data                   7             0 (  0%)
    Microsoft.Windows.Client.Vista.Dataset.ShellPerf Daily aggregations        91             0 (  0%)
    Microsoft.Windows.Client.Win7.Dataset.ClientPerf Raw data                   7            16 (  0%)
    Microsoft.Windows.Client.Win7.Dataset.ClientPerf Daily aggregations        91            16 (  0%)
    Microsoft.Windows.Client.Win7.Dataset.DiskFailure Raw data                   7             0 (  0%)
    Microsoft.Windows.Client.Win7.Dataset.DiskFailure Daily aggregations       182            32 (  0%)
    Microsoft.Windows.Client.Win7.Dataset.Memory Raw data                   7             0 (  0%)
    Microsoft.Windows.Client.Win7.Dataset.Memory Daily aggregations        91             0 (  0%)
    Microsoft.Windows.Client.Win7.Dataset.ShellPerf Raw data                   7             0 (  0%)
    Microsoft.Windows.Client.Win7.Dataset.ShellPerf Daily aggregations        91             0 (  0%)
    Performance data set           Raw data                  10       453,304 (  0%)
    Performance data set           Hourly aggregations       10       928,008 (  0%)
    Performance data set           Daily aggregations        30        62,504 (  0%)
    State data set                 Raw data                  10       162,992 (  0%)
    State data set                 Hourly aggregations       10       751,856 (  0%)
    State data set                 Daily aggregations        10       362,416 (  0%)

    Tuesday, January 3, 2017 6:51 AM

All replies

  • Hi,
    Appreciate you for posting questions in the Directory Service forum, however, the question is related to SCOM, in this case, I would suggest that you could post it in the System Center Operations Manager forum:
    https://social.technet.microsoft.com/Forums/windowsserver/en-US/home?category=systemcenteroperationsmanager
    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.
    Best regards,
    Wendy

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

    • Proposed as answer by Mr XMVP Tuesday, January 3, 2017 12:08 PM
    Tuesday, January 3, 2017 8:21 AM
    Moderator