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 |
|
bissa
Starting Member
32 Posts |
 Posted - 2012-05-09 : 21:33:51
|
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% |
|
|
bissa
Starting Member
32 Posts |
Posted - 2012-05-10 : 01:27:43
|
| 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 changeALTER INDEX ALL ON dbo._tablenameREBUILD WITH (FILLFACTOR = 90);ALTER INDEX ALL ON dbo._tablenameREORGANIZE WITH ( LOB_COMPACTION = OFF ) |
 |
|
|
|
|
|
Maintenance Plans