I am currently tasked with an incident to optimize the current MP that we are running on one of our PROD server. The size of the DB is 125GB and are running the MP on a daily basis. Following are the tasks with the MP.
Check DB Integrity -> Shrink Database -> Rebild Index
I am asked by the management to optimize the MP to achive better perfromance. Could you please let me know if the sequence that I am using has no issues? Also please advice if there are any steps that i am missing.
Version : SQL Serve 2005
OS: Windows 2003.