The Database has grown very large, how can I fix it?

Products

• Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Problem
The Database has grown very large, how can I fix it?

Environment
NS 6.0, all service packs

Cause

When the Purge Maintenance schedule executes, it usually times out due to the number of items it's trying to delete.  The result is that nothing gets purged, and the Database Tables continue to grow.

Resolution
The first step to resolution is to find out which tables are taking up a lot of space in the Database.  Run the attached SQL script in Query Analyzer to determine which tables are the largest.

Then use the ManualPurge process in KB 31988 to get Purge Maintenance to work properly to trim down the database.

Purging can then be verified by running the attached SQL again.