Hi, I read that maintenance plan can help to improve sql performance and my server suffers from random slowdown at heavy load so maybe that can help? I never did any maintenance to my db before, it is a game server db, size is 5gb. I tried today to check the maintenace plans but there is many options and I'm afraid I break something. Is there recommended settings to choose? I just checked the fragmentation of the tables and they are over 50%
I managed to rebuild and reorganize according to the statistic sql gave me, much better now but still some tables when I check the statistic says it needs rebuild and some needs reorganize, rerun the maintenance plan on them doesn't change the fragmentation %, only 4 tables showing that from 30 tables, before all 30 tables showed higher fragmentation, but now there is a progress, trying to figure how to make this 4 remaining tables. I tried the commands manually on the specified tables but didn't change
Maintenance Plans
Posted - 05/09/2012 : 21:33:51
