SQL Server memang memanage memory secara otomatis, jadi user tidak "bisa" punya banyak kendali. Beda dengan oracle yang punya sekitar 30 settingan untuk memory jadi bisa di "tune" secara manual. However ...
Ada beberapa cara juga IMHO untuk membuat memory itu kecil: 1. pada database properties, ada option, ada recovery - pilih simple, jangan full 2. Autoshrink dimatikan. Kalau mau grow, lakukan secara manual. 3. Siapkan segment 10% dari total penggunaan. Contoh, kalau sudah 1 GB, siapkan empty space at least 100 MB 4. Hubungan antara RAM dan MDF / LDF. Hukum 10%. database file (MDF) dan log file (LDF) besarnya adalah 10% dari total RAM. Contoh kalo ram 1 GB, maka 1 buah MDF maksimum sebesar 100 MB. Dan LDF juga 100 MB. 5. Contoh kalau aplikasi sekarang sudah 1,3 GB data dan 150 MB log file, maka buat 13 MDF + 1 MDF extra kosong (ingat rule no 3) dan log file 2 LDF dan 1 buah LDF kosong. 6. Issue CHECKPOINT tiap malam. Gunakan scheduler pada jam 24 malam. Moga2x bantu .. :-) dexrs _____ From: [email protected] [mailto:[EMAIL PROTECTED] Sent: Monday, December 25, 2006 8:32 AM To: [email protected] Subject: Re: [ITCENTER] Penggunaan Memory di MS SQL server 2000 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] <mailto:bmwgue%40gmail.com> com> To: [EMAIL PROTECTED] <mailto:ITCENTER%40yahoogroups.com> s.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. <http://mail.yahoo.com> yahoo.com [Non-text portions of this message have been removed] [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/
