morglum666
Well Known Member
Hello,
We've recently upgraded to a windows platform using Win 2008 and SQL 2008R2. We have a roughly 25 gb business data plus control tables database.
We'd like to do some database indexing but it needs to be relatively fast given some users are always on the system including at night. I also think we need to reflect the use of web client and not necessarily index central objects all the time like when we had fat clients. I haven't worked with the specifics of setting up a SQL index plan and would be relying on our back end team but I would appreciate any comments or tips. I do not want to use a JDE UBE.
I was thinking:
Weekly - Database index of Business Data - Prod, Control Tables - Prod + Serialized object tables (F98999, F989998)
Monthly - Index everything not included in the weekly run.
Does that make sense? Too specific?
Cheers
Malcolm
We've recently upgraded to a windows platform using Win 2008 and SQL 2008R2. We have a roughly 25 gb business data plus control tables database.
We'd like to do some database indexing but it needs to be relatively fast given some users are always on the system including at night. I also think we need to reflect the use of web client and not necessarily index central objects all the time like when we had fat clients. I haven't worked with the specifics of setting up a SQL index plan and would be relying on our back end team but I would appreciate any comments or tips. I do not want to use a JDE UBE.
I was thinking:
Weekly - Database index of Business Data - Prod, Control Tables - Prod + Serialized object tables (F98999, F989998)
Monthly - Index everything not included in the weekly run.
Does that make sense? Too specific?
Cheers
Malcolm