SQL Server Performance Tips: Rebuilding Indexes

[Ryra Multipay]

Setelah beberapa lalu melakukan reindex pada otomaX (gara2 kena penyakit kuning)
Emang sangat terasa sekali perbedaannya... OtomaX terasa lebih ringan dan proses semakin cepat...

Nah, yang jadi pertanyaan,,
Apakah Re-Index ini perlu dilakukan secara berkala? Kalau perlu idealnya dengan interval berapa lama?
Kalau terlalu sering id re-index ada efek negatifnya ga?

Buat para master, ditunggu pencerahannya.. trims

[lintas]

Setelah beberapa lalu melakukan reindex pada otomaX (gara2 kena penyakit kuning)
Emang sangat terasa sekali perbedaannya... OtomaX terasa lebih ringan dan proses semakin cepat...

Nah, yang jadi pertanyaan,,
Apakah Re-Index ini perlu dilakukan secara berkala? Kalau perlu idealnya dengan interval berapa lama?
Kalau terlalu sering id re-index ada efek negatifnya ga?

Buat para master, ditunggu pencerahannya.. trims

Tul nich... spa yg tau tlg sharing...

[joll]

Nunggu screen cara reindex nya maaf newbie ;)

[abg_dewata86]

Betul bgt bos, mudah2an ada yg sukarela bwt manual book spt wkt instal awal step by step beserta picnya.
Pastinya semua setuju, ngarep.com  ;D ;D

memantau sekalian menunggu mode on.  8) 8)

[SapiLanang]

sodara2, file mdf saya udah 1,8 giga.. maw nangis.. berat bgt. baru jalankan query ini alhamdulilah enteng

hemh,, bisa tidur nyenyak

[spiderbooo]

sodara2, file mdf saya udah 1,8 giga.. maw nangis.. berat bgt. baru jalankan query ini alhamdulilah enteng

hemh,, bisa tidur nyenyak

Wuih..1,8GB itu data brpa abad bos kl bagi saya..tp kl bagi bos,mungkin cuma 1 bulan kali ya  ;D

[United Tronik]

Wediann....muanteb bosss...kerasa banget bedanya...biasanya search trx lambat gila..sekarang lancar...mantap jaya...

Unitedtronik

[ipin31444]

sodara2, file mdf saya udah 1,8 giga.. maw nangis.. berat bgt. baru jalankan query ini alhamdulilah enteng

hemh,, bisa tidur nyenyak

Wuih..1,8GB itu data brpa abad bos kl bagi saya..tp kl bagi bos,mungkin cuma 1 bulan kali ya  ;D

punyaku baru 1,2gb
trx tetap aman terkendali.

[ircpulsa]

akhirnya ngalami juga otomax suspect  :'( :'( :'( :'( :'(
untunggya para suhu dah posting disini cara atasinya alhamdulillah sudah beres
da reindex telah di lakukan sesuai prosedur.....

makasih semuanya terutama buat Bos Yusuf ..
dan seseorang yang jauh disana (sulawesi) thanks ya bro

[LUCKY]

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
Msg 16916, Level 16, State 1, Line 20
A cursor with the name 'TableCurso' does not exist.



ada yg merah knapa ya ???
maklum newbie

[alaska]

all tq beud  ;D

[PulsaHP.com]

akhirnya ngalami juga otomax suspect  :'( :'( :'( :'( :'(
untunggya para suhu dah posting disini cara atasinya alhamdulillah sudah beres
da reindex telah di lakukan sesuai prosedur.....

makasih semuanya terutama buat Bos Yusuf ..
dan seseorang yang jauh disana (sulawesi) thanks ya bro

database suspect itu yang seperti apa ya, mohon pencerahannya

[Masterajat]

apa ada solusi ????


DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.


The statement has been terminated.
Msg 1105, Level 17, State 2, Line 11
Could not allocate space for object 'dbo.SORT temporary run storage:  422214188335104' in database 'otomax' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup