GP Database Checking with DBCC

(0) Share

Report

Posted on by Richard Wheeler

75,730

I have an issue with sales orders. We enter about 200-300 sales orders per day. Database size is approaching 25GB. A user will be entering sales order, one line after another and then suddenly the ship to address code just stops being carried down to subsequent lines. This hapens only 1 or 2 times per month so I cannot reproduce it. They know it has happened because when they go to print out the PO comitted to this SO, they get mulitple PO's printing. DBCC CheckDB does not return any consistency errors. My thinking it is may be time to rebuild the indexes in the GP database. What fillfactor setting should I use with the DBCC REINDEX command so the indexes will have the exact same structure when the rebulding is complete?

*This post is locked for comments