Dennis can you clarify this process or list a procedure?
o DBCC SHRINKFILE (<FormsDB_Log>, 1024, TRUNCATEONLY)
o USE <ReportsDB>
o DBCC SHRINKFILE(<Reports_Log>,1024,TRUNCATEONLY)
– Reindexing of tables having high rate of fragmentation. This can be achieved by invoking a store procedure (Script provided by Perfectforms along with installer)
o Execute the Store procedure as given below
EXEC <FormsDB>.adm.Index_Defrag 10, 30, 1
EXEC <ReportsDB>.adm.Index_Defrag 10, 30, 1 ).