サポートと今すぐチャット
サポートとのチャット

MessageStats 7.8.1 - 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

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.

Managing Audited Information

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.

 
* 
IMPORTANT: Before you modify your 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.
Prerequisites

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.)

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:

•
the MessageStats service account
•
the account that is currently logged into the MessageStats console
To access the Database Management functionality
•
Select Database Management from the treeview.

The Database Management tool provides the following functionality:

•
Database Aging (For more information, see Deleting Historical Data .)
•
Database Maintenance (For more information, see Database Maintenance— Reindexing and Defragmenting the Database .)
•
Deleting Data (For more information, see Deleting Object or Report Data .)

Database Management Statistics

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.

 
Table 1. Viewing information about the MessageStats database.
Title
Information Reported

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:

•
Decrease the size of your database while retaining data that may be required in the future.
•
Decrease the amount of time it takes the task processors to write information to the MessageStats Database.
•
Decrease the amount of time it takes MessageStats Reports to read information from the database to render reports.
関連ドキュメント

The document was helpful.

評価を選択

I easily found the information I needed.

評価を選択