Server Management Suite

 View Only

  • 1.  Truncate Table MonitorMetricData

    Posted Mar 02, 2011 11:12 PM

    Is it ok to truncate the MonitorMetricData table? Mine has over 25M records and the Monitor Solution portal is crawling.



  • 2.  RE: Truncate Table MonitorMetricData

    Broadcom Employee
    Posted Mar 03, 2011 03:35 AM

    Hi NoodleNT,

    I would say backup the data first, in case you need it later.

    You have the option to copy the table to another DB (created by you or your DBA team) on the same SQL server (so the size and copy won't be impacting the Monitor platform) or copy to an archive SQL or event to a plain (csv) file (but that may be very impractical).

    Do this only if you are confident no-one is needing or using the data now ;).



  • 3.  RE: Truncate Table MonitorMetricData

    Posted Mar 03, 2011 12:22 PM

    My MonitorMetricData table currently has 127M rows in it.

    What about Monitor solution is running slow?