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.

To define a data aging task
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).
4
Enter the number of days to retain statistical and audit data in your database.
You might want to remove audit information more often than statistics. Audits can rapidly increase the size of your database.
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.
Depending on the schedule type that you select, the bottom box changes to an appropriate interval selector.
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.
9
Enter an appropriate recurrence interval:
•
Enter the number of days between jobs for Daily schedules.
•
Enter the day of the week for Weekly schedules.
•
Enter the day of the month for Monthly schedules.
10
Click Deploy.
About the Age Audits Option

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

•
Organizations | Subject Auditing | Subject Sent Audits
•
Organizations | Subject Auditing | Subject Received Audits
•
Servers | Delivery Times | Message Delivery Audit
•
Mailboxes | Mailbox Auditing | Mailbox Sent Audits
•
Mailboxes | Mailbox Auditing | Mailbox Received Audits
•
Internet | Internet Domain Auditing | Domain Inbound Audits
•
Internet | Internet Domain Auditing | Domain Outbound Audits
Data Aging Job History

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

•
The Schedule tab contains the same content as the Create Job tab had before a job was created.
•
The Properties tab describes the properties associated with the aging job, and is updated as new information becomes available.
•
The History tab contains a log of past aging jobs.
Logging the Aging Progress

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

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.

 
* 
IMPORTANT: Before you reindex or defragment the database, ensure that no MessageStats consoles are currently writing information to the database. If you use Database Management while a MessageStats console is writing to the database, you risk corrupting your 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:

•
Decrease the amount of time it takes the MessageStats task processors to write information into the database.
•
Decrease the amount of time it takes MessageStats Reports to read information from the database to render your reports.
 
Table 2. Options for scheduling database maintenance tasks.
Recommended alternatives for database maintenance

Resource Intensive
•
Schedule the Reindex job to run every day after all the gathering tasks have completed.

Less Resource Intensive
1
Schedule the Defragment job to run every weekday (Monday through Friday) after all the gathering tasks have completed.
2
Schedule the Reindex job to run on the weekend (or once a month) after all the gathering tasks have completed.

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.

To create a 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.
Depending on the schedule type that you select, the bottom box of the dialog box changes to an appropriate interval selector.
4
Enter a Start Date and Start Time in the respective boxes.
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.
6
Enter an appropriate recurrence interval:
•
Enter the number of days between jobs for Daily schedules.
•
Enter the day of the week for Weekly schedules.
•
Enter the day of the month for Monthly schedules.
7
Click Deploy.
Reindexing Job History

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

•
The Schedule tab contains the same content as the Create Job tab displayed before a job was created.
•
The Properties tab describes the properties associated with the reindexing job, and is updated as new information becomes available. If you want to start an immediate Reindex job, you can click the Start button on this tab.
•
The History tab contains a log of past reindexing jobs.

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.

To create a defragmentation 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.
Depending on the schedule type that you select, the bottom box of the dialog box changes to an appropriate interval selector.
4
Enter the Start Date and Start Time information in the respective boxes.
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.
6
Enter a recurrence interval:
•
Enter the number of days between jobs for Daily schedules.
•
Enter the day of the week for Weekly schedules.
•
Enter the day of the month for Monthly schedules.
7
Click Deploy.
Defragmentation Job History

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

•
The Schedule tab contains the same content the Create Job tab had before a job was created.
•
The Properties tab describes the properties associated with the defragmentation job, and is updated as new information becomes available. To start an immediate Defragment job, click the Start button on this tab.
•
The History tab contains a log of past defragmenting jobs.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating