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

book

Article ID: 179881

calendar_today

Updated On:

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.

Attachments

Database Table Size Query.txt get_app
Database Table Size Query.txt get_app