McAfee QUICKCLEAN 1.0 User's Guide Page 28
- Page / 74
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
6
Click Save.
7
Select Database Maintenance | Status to see
progress for scheduled maintenance jobs that have
completed or are running.
Rebuild indexes
Perform index rebuilding to prevent or correct performance issues.
Over time, there are many changes made to database indexes that result in degraded performance.
Degraded performance occurs when the index becomes fragmented. In McAfee Content Security
Reporter, fragmentation occurs each time you import data, or delete data. Degraded performance
affects importing logs, database maintenance jobs, and generating reports. On the database server,
degraded performance can result in a high CPU load and high paging rate.
Set when to rebuild the indexes
By default, indexes are rebuilt every month on a Sunday.
Perform maintenance during off-peak times. During maintenance, the database and new queries and
reports
are not available.
Task
F
or option definitions, click ? in the interface.
1
Select Menu | Configuration | Report Server Settings.
2
Click Database Maintenance, then click Edit.
3
Edit the frequency of the jobs, and the day on which you want them to occur, or deselect the
checkbox to cancel the index rebuilding jobs.
4
Click Save.
the maintenance job appears in Database Maintenance | Status.
Set up regular index rebuilding jobs
Schedule index rebuilding to run at regular intervals during database maintenance jobs.
Before you begin
Ensure that you schedule index rebuilding on a day that you normally schedule your
database maintenance. If you scheduled index rebuilding for Monday, but you do not have
regularly scheduled database maintenance on Mondays, then the index rebuilding job will
not run.
When you schedule index rebuilding, it runs according to the frequency you select (weekly or
monthly),
on the day of the week you select, and will run at the same time of day that you scheduled
database maintenance.
For example, your regularly scheduled database maintenance is daily on Saturday, Sunday, and
Wednesday at 12:01 a.m. You configure index rebuilding every week on Sunday. Index rebuilding will
run as part of the regularly scheduled maintenance on Sundays at 12:01 a.m.
Schedule maintenance during off-peak times. During maintenance, the database and new queries and
reports
are not available.
4
Maintain the database
Database
maintenance
28
McAfee Content Security Reporter 1.0.0 Software Product Guide
- Software 1
- COPYRIGHT 2
- TRADEMARK ATTRIBUTIONS 2
- LICENSE INFORMATION 2
- License Agreement 2
- Contents 3
- About this guide 5
- Find product documentation 6
- Introduction 10
- System requirements 11
- Download the software 12
- Install the extensions 13
- Register the report server 13
- Report Server Settings menu 14
- Configure the interface 15
- Remove the extensions 16
- Uninstall McAfee 17
- Content Security Reporter 17
- Configure the database 19
- Introduction to 20
- External database use 21
- Database page 22
- Execute SQL use 23
- Maintain the database 25
- Database Maintenance page and 26
- Edit Database Maintenance 26
- Database records maintenance 27
- Rebuild indexes 28
- Manual Maintenance page 29
- Delete records by log source 30
- Database records updates 30
- Manual index rebuilding 31
- Get database statistics 31
- View the 32
- Log sources and log formats 33
- Log formats 34
- Log Sources page 35
- Current Jobs page 36
- Statistics page 37
- Schedule when to process logs 37
- Guide to User-Defined Columns 38
- Log Sources 39
- Process incoming log files 40
- Job Queue page 41
- Custom columns 41
- Custom Column list 42
- Edit Rule Set dialog box 42
- Rule sets 43
- Custom Rule Sets page 44
- Browse time threshold 45
- Content 47
- Security Reporter queries 47
- Content Securit 48
- Configure reports 49
- Schedule reports and queries 49
- Dashboard monitors 50
- Configure a new dashboard 50
- Performance, maintenance, and 53
- Performance Options page 54
- Summary Cache page 55
- System Backup page 56
- Configuration settings backup 57
- Support page 58
- Support 59
- Fixed-field log formats 67
- 700-3703A00 74
Related products and manuals for Database software McAfee QUICKCLEAN 1.0
(32 pages)© 2020, manymanuals.com. All rights reserved. | 0.448 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals