Re: Timeout error after 20 seconds max

Home Forum General Timeout error after 20 seconds max Re: Timeout error after 20 seconds max

#6032

Anonymous

Dennis can you clarify this process or list a procedure?

USE <FormsDB>

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