How to Reduce the Total Amount of Data in the WebWatchBot Database

From WebWatchBotWiki
Jump to: navigation, search
 Share 

Summary

Over time, the total amount of data in the WebWatchBot database will grow as data is collected for Watch Items and Transactions. The performance of WebWatchBot and SQL Server are directly affected by the amount of data in the database. SQL Server's performance can be dramatically improved by increasing the amount of resources allocated (CPU time and/or memory) or by reducing the amount of data. This article assists in reducing the amount of data in the WebWatchBot database.

Solution

  1. Run the Database Report (Tools -> Database -> Report), to determine the total amount of data in the database. The completed report will show "Total Table Rows".
  2. Remove data from Watch Items
    1. In WebWatchBot Manager, select the "All" filter in the Explorer's Control Panel, so that all of the Watch Items are visible
    2. Select all of the Watch Items in the Watch List by pressing the key combination Ctrl-A or by selecting one or more Watch Items by holding the Ctrl or Shift key while left clicking with the mouse.
    3. Select the menu options: Tools -> Database -> Remove Old Data
    4. Enter the amount of time to remove old data. The amount of time necessary to reduce the total data in the database will vary depending on when and how much data is collected. "Remove data older than 3 months" is the recommended starting point.
    5. Click OK to begin removing old data
  3. Remove data from Transactions
    1. Select a Transaction in the Explorer Control Panel, then select the Transaction Summary and all of its steps in the Watch List by pressing the key combination Ctrl-A or by selecting one or more Watch Items by holding the Ctrl or Shift key while left clicking with the mouse.
    2. Select the menu options: Tools -> Database -> Remove Old Data
    3. Enter the amount of time to remove old data. The amount of time necessary to reduce the total data in the database will vary depending on when and how much data is collected. "Remove data older than 3 months" is the recommended starting point.
    4. Click OK to begin removing old data
  4. When complete, run the Database Report (Tools -> Database -> Report), to determine the total amount of data in the database. The completed report will show "Total Table Rows". Repeat the above proces, decreasing the amount of time to remove old data, until the total amount of data is reduced to the desired level - your results and performance will vary, and there is no set amount of data for all systems.
  5. After finalizing the removal of old data, run Database Maintenance (Tools -> Database -> Database Maintenance) to optimize the database for performance.

Other Information

This process can be automated by Scheduling Database Maintenance