How can we help you today? How can we help you today?

SQL Monitoring ver 8.0.22.18060 data purge issue

I am having issue with space I have one table data.Cluster_SqlServer_Database_File_UnstableSamples has over 15 B rows(15918979993) and data going back more then 6 months, I have the data purge for for Storage data set to 1 day ? This table is taking up around 800 GB or 1/3 of my DB it's not the only one that has some large row counts. 

What should I do about this how do I force a data clean up ? 
Scott
0

Comments

2 comments

Sort by
  • Russell D
    With a table that size its possible purging just can't keep up. You can just delete from that table where everything is over a certain date. 

    I would advise ensuring you have a valid working backup before deleting any data though.
    Russell D
    0
  • Scott_humphrey
    Thanks I did start to do that already figure it was some type of broken ID issue it just so big can't really do any trouble shooting with out sitting at a SSMS screen for days 

    I will work on clearing the data out it getting smaller 



    Scott_humphrey
    0

Add comment

Please sign in to leave a comment.