Specifications

Setting up a maintenance task to automatically reindex and rebuild your ePolicy Orchestrator SQL
database only takes a few minutes and is essential to maintain proper performance on the McAfee ePO
server. You can include the re-indexing as part of your regular backup schedule to combine everything
in one task.
Do not shrink your database. This is a common misconception that
many administrators choose when building their maintenance task.
To learn the details on creating your maintenance task, see KnowledgeBase article KB67184.
You can learn more about database fragmentation and how to determine the fragmentation of your
database, use the DBCC command found in the Understanding SQL Server's DBCC SHOWCONTIG
article, found at http://www.sql-server-performance.com/articles/dba/dt_dbcc_showcontig_p1.aspx.
13
SQL maintenance
ePolicy Orchestrator SQL database maintenance
106
McAfee
®
ePolicy Orchestrator
®
4.0 and 4.5 Best Practices Guide