Chat now with support
Chat con el soporte

MessageStats 7.5.1 - Administrator Guide

What is MessageStats? MessageStats Information Sources Creating a Connection to Exchange Using the Console Interface Creating Gathering Tasks Default Gatherings Extending Gathering Tasks Configuring Audits Setting Configuration Properties Setting MessageStats Server 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

Managing your MessageStats Database

The MessageStats Database stores the information that is used by MessageStats Reports. When the database is properly tuned, information can be efficiently stored, and MessageStats Reports can quickly access the required data.

Over time, the MessageStats Database will grow, and the database server can become taxed. However, it is critical that the database retain enough data for any historical reporting needs that may arise.

To manage your MessageStats Database, you can use the Database Management functionality to selectively delete obsolete data and to tune the database for optimal performance.

Audits affect both the overall size of your database and gathering performance time. It is recommended that you carefully select the audits that you want to perform, and retain audit information for as little time as possible to avoid increasing the size of your database too rapidly.

Using Database Management

MessageStats allows you to optimize the storage of tracking log and Exchange object data to prevent excessively rapid growth of your database. Using Database Management, you can delete obsolete information and tune your database.

For Database Management functions to be available, the SQL Server agent must be installed and running on the SQL Server. (SQL Server agent is not included in SQL Server Express.)

For distributed installations, SQL Distributed Management Objects (SQL-DMO) must be installed on the server that hosts the MessageStats MMC console. For more information, see “MessageStats-Specific Requirements” in the MessageStats Quick Start Guide

To use the Database Management features in a distributed environment, one of the following accounts must have the sysadmin fixed server role on the SQL server that hosts the MessageStats database:

Select Database Management from the treeview.

The Database Management tool provides the following functionality:

Database Management Statistics

When you select the Database Management node, the Database Management database information page is displayed.

This page provides statistics about your MessageStats Database that you can review before you perform any database management actions.

SQL Server Edition

The version information about the SQL Server software on which the database resides.

Database Created on

The date and time when the database was created

Last Database Backup on

When the database was last backed up.

Database Size

The database size including the amount of free space and the amount of used space.

MessageStats Database Build

The version number of the MessageStats database that is installed.

MessageStats Application Build

The version number of the MessageStats application software that is installed.

Deleting Historical Data

You can use the Data Aging function to delete the historical data from your database. By deleting historical data, you can increase MessageStats performance in the following ways:

Documentos relacionados