sql server 2005 maintainance plan good practice....
-
Dear Friend, help me come out of this issue.... i have one application on which more then 1000 user access daily and its create huge data transaction which need to be manage. we have maintainance plan which run on weekly basis. but still some time it slower down help me for this... tell me some good practice for this issue... i have some questions 1. What is statistics job does. 2.What task(s) is/are suitable for daily maintenance and what for weekly/monthly maintenance 3.Do database need to be offline while in some task, example : reorganize/rebuild index, Shrinking database, etc... (since we need to keep 90% uptime) 4.How long can check database integrity, reorganize/rebuild index, cleanup history be? 5.Should we do both reorganize and rebuild index? 6.Do we need to update statistic after reorganize index? Since rebuild index will auto update statistic Please help me asap.. thanks
Sasmi
-
Dear Friend, help me come out of this issue.... i have one application on which more then 1000 user access daily and its create huge data transaction which need to be manage. we have maintainance plan which run on weekly basis. but still some time it slower down help me for this... tell me some good practice for this issue... i have some questions 1. What is statistics job does. 2.What task(s) is/are suitable for daily maintenance and what for weekly/monthly maintenance 3.Do database need to be offline while in some task, example : reorganize/rebuild index, Shrinking database, etc... (since we need to keep 90% uptime) 4.How long can check database integrity, reorganize/rebuild index, cleanup history be? 5.Should we do both reorganize and rebuild index? 6.Do we need to update statistic after reorganize index? Since rebuild index will auto update statistic Please help me asap.. thanks
Sasmi
This is where DBAs earn their living, I suggest you either start reading a number of articles on database specific sites (sqlservercentral is one) or hire a DBA consultant to design a maintenance regime for you.
Never underestimate the power of human stupidity RAH
-
This is where DBAs earn their living, I suggest you either start reading a number of articles on database specific sites (sqlservercentral is one) or hire a DBA consultant to design a maintenance regime for you.
Never underestimate the power of human stupidity RAH
I agree with Mycroft (second time today) this is more of an art than a "do it this way" type thing. There are so many variables that there is no easy answer. Some things to look into (learn about) would be Data Base Tuning Advisor and audit trace for a start. These may or may not help. There are also several third party programs that might help, again Google may help. You might look at Idera as one provider.