Are there any best practices or caveats for re-indexing Sage 300 Databases using Microsoft SQL Server's maintenance plans?
Thank you in advance for any suggestions!
Are there any best practices or caveats for re-indexing Sage 300 Databases using Microsoft SQL Server's maintenance plans?
Thank you in advance for any suggestions!
This is a great question!
My long-term approach has been to schedule a re-organize of indexes Monday-Saturday nightly, and a re-build of indexes on Sunday nights. As you would know be careful not to schedule…
No worries, I was a bit vague on the Missing Indexes part. Basically what I do is ask the users to perform the activity that is running slow, then open the Activity Monitor -> Expensive queries -> Show…
Daily rebuilds are a waste of CPU cycles. Once a month is plenty.
Daily rebuilds are a waste of CPU cycles. Once a month is plenty.
Jay, Thank you for this feedback.