Cleanup obsolete request data from database
Due to a bug in the Data Volume Management job shipped with FusionAnalytics 1.0.4, parts of the request data in tables REQUEST_AMF and REQUEST_PARAM are not deleted from the database.
To cleanup your database and remove the obsolete data you can download this script and run it on your FusionAnalytics database server.
Before Starting Please Note
Example: It will take between 10 to 20 minutes on an environment that has a 200GB database that is installed on a standard HDD and has 40 Million (40,000,000) obsolete rows
USE [FADB] GO declare @totalRows int, @rowsToKeep int ...
When the script has finished you should see the following messages:
(_n_ row(s) affected) Caution: Changing any part of an object name could break scripts and stored procedures. (_n_ row(s) affected) Caution: Changing any part of an object name could break scripts and stored procedures.
Where n is some number of rows