Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vna_mhars
Starting Member
37 Posts |
 Posted - 2010-11-27 : 10:33:23
|
| Hi, I have 89Gb of Database. I would like to ask if is it good to do optimization, update stastistic to that database? Aside from doing the optimization,update statistic to the MSDB and MASTER, what else can be the good maintenace plan for the database? Anyone from the expert can help me? Thank you..vamodente |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-27 : 11:45:17
|
| Do you have backups in place?Apart from that everything else depends on how the system is used.Only update statistics and indexes and defrag when it's necessary. I've seen systems where it's done daily and others not at all or on an ad hoc basis.Remember that these processes can affect your backup strategy - increasing the size of tr log ane differentials so you may need to change when these are taken if you implement anything.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
vna_mhars
Starting Member
37 Posts |
Posted - 2010-11-29 : 20:58:26
|
| Thanks you..Is there any disadvantages of using Update statistics?Regards,vamodente |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-29 : 21:40:26
|
| It uses resources.Can cause a change in query plan - that's usually a good thing but might not be in some instances.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Maintenace Plan