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 |
|
sqlserverdba
Yak Posting Veteran
53 Posts |
 Posted - 2008-12-12 : 09:53:14
|
| Hi,I've 200Gb DB SIZE and users are noticing Month end processing longer than earlier since 3-4 months and every month processing time taking longer and longer.Please advice what to do.Memory looks fine on server during Month end processing.I noticed couple of locks, what would be best way to fix such kind of locking?ANy advice would be great. Does rebuilding the indexes help?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-12 : 09:56:26
|
| Do you have any planned maintyainence activities towarsd every month end? like indexing, defragmenting,...? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-12 : 10:38:24
|
quote:
Originally posted by sqlserverdba
Does rebuilding the indexes help?Thanks
Did you check with DBCC SHOWCONTIG to see fragmentation before you rebuild or Defrag? |
|
|
|
sqlserverdba
Yak Posting Veteran
53 Posts |
Posted - 2008-12-15 : 09:51:50
|
| Yes, I did run DBCC SHOWCONTIG and it showing fragmentation info.Please advice.thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-15 : 09:54:37
|
| Then rebuild or Defrag depending on Fragmentation level. |
|
|
|
sqlserverdba
Yak Posting Veteran
53 Posts |
Posted - 2008-12-15 : 11:21:09
|
| Hi,Do you need to keep same fillfactor during running DBCC DBREINDEX or need to change fillfactor value?Any other suggestion?Thanks, |
|
|
|
sqlserverdba
Yak Posting Veteran
53 Posts |
Posted - 2008-12-16 : 10:09:36
|
| Does any one have script which rebuild/defrag all required indexes ?thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-16 : 10:48:51
|
| what did you find when you search in SQLteam.com? |
|
|
|
|
|
|
Month End processing slow