[FNS-32] Cleanup obsolete request data from database

Cleanup obsolete request data from database

Description
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

• You will require full access to your FusionAnalytics Database Server and all permissions such as create and delete tables.
• You will need to specify the database name that is used by FusionAnalytics in the script (see instructions below)
• This script might take a long time to execute. This is dependent on the following factors:
  • The size of your database.
  • The performance of the hardware where the database is installed.
  • The number of rows that became obsolete.

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

Instructions

1. Download this script
2. Open SQL Management Studio
3. Login as an existing user with system administrator privileges.
4. Navigate to File -> Open -> File
5. Navigate to the folder where the script is located and select it
6. At the top of the script enter your FusionAnalytics database name into the square brackets “[]”
   If your database name is “FADB” then it should look like this:

   USE [FADB]
   GO
   
   declare @totalRows int, @rowsToKeep int
   ...

7. Click the Execute button

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