SQL Monitoring ver 8.0.22.18060 data purge issue

Scott_humphreyScott_humphrey Posts: 2 New member
edited March 15, 2019 11:11AM in Redgate Monitor
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 ? 
Tagged:
· Share on Twitter

Best Answer

  • Russell DRussell D Posts: 1,324 Diamond 5
    Answer ✓
    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.
    Have you visited our Help Centre?
    · Share on Twitter

Answers

  • Scott_humphreyScott_humphrey Posts: 2 New member
    edited March 15, 2019 2:38PM
    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 



    · Share on Twitter
Sign In or Register to comment.