Chat now with support
Chat with Support

MessageStats 7.7.2 - Administrator Guide

What is MessageStats? MessageStats Information Sources Using the Console Interface Creating a Connection to Exchange Creating Gathering Tasks Default Gatherings Extending Gathering Tasks Configuring Audits Setting MessageStats Server Properties Setting Configuration Properties Setting Exchange Organization Properties Setting Exchange Server Properties Setting Task Execution Server Properties Setting Task Default Properties Compressing Tracking Log Files Using the MessageStats Reports Console Database Management Appendix A:Microsoft ASP.NET Configuration Issues Appendix B: Gathering Task Dependencies Appendix C:Troubleshooting Permission Problems

Configuring a Data Aging Task

You can use the Data Aging node to define a recurring task to remove data that is older than a specified time period.

You can set different schedules for deleting statistics and for deleting audit information in your database. For example, you might want to remove audit information more frequently, as audits rapidly increase the size of your database.

1
Expand the Database Management | Data Aging nodes in the treeview.
2
Select Delete aged data.
3
Specify the type of data to be aged: Age Statistics (days) and/or Age Audits (days).
5
Click Configure Job.
6
Select Daily, Weekly, or Monthly to indicate how often you want to delete the data older than your retention definitions.
7
Enter the Start Date and Start Time information.
8
Click to select the Limit Job Execution Time box if you want to limit the time duration for an aging job, and enter an end time.
10
Click Deploy.

The Age Audits (days) option will age data for the following reports:

After you create a job, the interface changes to a three-tab format:

Because the aging process is performed by a service, progress is recorded in the log journal for all database management activities.

The log information is available in the MessageStats log journal, so activity can be viewed on the MessageStats Gathering reports by filtering the Source field by Stats Data Aging or Audit Data Aging values.

Database Maintenance—Reindexing and Defragmenting the Database

The Database Maintenance node of the navigation tree contains the functionality to reindex the individual database tables and to defragment the database.

The Reindex option completely reindexes each table in the database. The Defragment option simply defragments the indexes.

If you run the Reindex option, you do not need to run the Defragment option since there is nothing to defragment if all the indexes are new.

Using these functions can increase performance in the following ways:

Resource Intensive

Less Resource Intensive

Reindexing the Database Tables

MessageStats provides functionality to reindex database tables. The Create Job tab of the Reindex dialog box appears until you define your first reindexing job.

1
Expand the Database Management | Database Maintenance nodes in the treeview.
2
Select the Reindex node.
3
Select Daily, Weekly, or Monthly from the Schedule type box.
5
Select the Limit Job Execution Time box if you want to limit the duration of a reindexing job, and enter an appropriate end time.
7
Click Deploy.

After you create a job, the Reindex interface changes to a three-tab format:

Defragmenting the Database

Use the Defragment option to defragment your database. The Create Job tab of the Defragment dialog box appears until you define the first defragmenting job.

1
Expand the Database Management | Database Maintenance nodes in the treeview.
2
Select the Defragment node.
3
Select Daily, Weekly, or Monthly from the Schedule type box.
5
Select the Limit Job Execution Time box if you want to limit the duration of time for a defragmenting job, and enter an end time.
7
Click Deploy.

After you create a job, the Defragment interface changes to a three-tab format:

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating