February 2, 2010 at 12:13 am
Hi,
As of now my sql database is 2gb, daily growth increasing as a dba what are all the task need to create in maintenance plans for database performence like DBCC command rebuilding indexes etc....
can u please suggest some more task for the production server live database we r using sql server
8.00.2039 SP4 Personal Edition
please sugest
Thanks in advance
February 2, 2010 at 4:27 pm
What kind of window for off-peak usage hours do you have? I would suggest scheduling jobs during off-peak hours to complete the following:
- rebuild all indexes (since your database is only 2GB; this may need to be modified as the maint plan takes longer to accomplish)
- check database integrity, backup the database
Joie Andrew
"Since 1982"
February 3, 2010 at 4:28 pm
The topic title suggests you want to know about forecasting database growth, but the content is that you want to know which maintenance to apply.
Do you want to know about growth forecasting?
March 22, 2010 at 4:07 am
yes ineed to do this Do you want to know about growth forecasting?
as well with regular dba task to increase the performence of the DB
monthly my db grows ~1gb
thanks in advance
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply