IMHO, shrink itu malah memperparah performance, lagian dia kan hanya memotong space database yang nggak kepake? bukan membersihkan penggunaan memory di SQL.
Best Regards, Ade Aan Wirama ----- Original Message ---- From: Michael <[EMAIL PROTECTED]> To: ITCENTER@yahoogroups.com Sent: Saturday, December 23, 2006 10:32:57 AM Subject: Re: [ITCENTER] Penggunaan Memory di MS SQL server 2000 Naek trus krn sebenarnya sql itu ga pernah delete data2.... Artinya semua log nya maseh kesimpen... Coba aja Shrink database.... .. smg membantu.... tq On 12/22/06, Hadi Hidayat <[EMAIL PROTECTED] com> wrote: > > Rekan-rekan > gimana yah cara mengclean mem usage di server yang menggunakan MS sql > 2000, > saya perhatikan mem usage nya cenderung naik terus, lalu giman > menormalkannya kembali? > > best regard > hadi > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed] __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] ## Jobs: itcenter.or.id/jobs ## Bursa: itcenter.or.id/bursa ## ## Jaket ITCENTER tersedia di http://shop.itcenter.or.id Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/