Author Topic: SQL Server Performance Tips: Rebuilding Indexes  (Read 29460 times)

::ryra ceLL::

  • Reseller OtomaX
  • Sr. Member
  • ****
  • Posts: 1,204
  • OtomaX Ultimate 3.7.6
    • Server Pulsa All Operator & PPOB
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #40 on: December 27, 2010, 06:05:38 AM »
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
Melayani Pembelian, Upgrade, Iuran Tahunan, Ganti Dongle, dan Balik Nama OtomaXTelp|SMS|WA : 085641234275 | 085270444555
Telegram: @ryraceLL | BBM : D54691EA
| www.ryracell.co.id Server Pulsa All Operator & PPOB Online
| www.ryrawebhost.com Domain, Hosting, Reseller, Web Design

lintas

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 205
    • Lintas Pulsa Pratama
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #41 on: December 27, 2010, 09:59:30 AM »
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...
Otomax Ultimate

joll

  • User OtomaX
  • Full Member
  • ***
  • Posts: 560
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #42 on: December 27, 2010, 10:45:16 PM »
Nunggu screen cara reindex nya maaf newbie ;)
Otomax Ultimate
JL.At taqwa no 34 blangpidie aceh barat daya
telp.065991699,HP.082273731000,2B979E46
Jagoan nya voucher orange tv,k-vision,topaz tv

abg_dewata86

  • User OtomaX --
  • Jr. Member
  • **
  • Posts: 145
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #43 on: February 05, 2011, 06:02:41 PM »
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)
Menabung untuk bisa membeli versi full OTOMAX, i have dream come true. Dan saat ini
Mengumpulkan pundi untuk bisa upgrade ke advance bahkan kalo bisa sxan unlimited (jika pundinya cukup)  :D :D

SapiLanang

  • Newbie
  • *
  • Posts: 36
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #44 on: February 14, 2011, 12:08:54 AM »
sodara2, file mdf saya udah 1,8 giga.. maw nangis.. berat bgt. baru jalankan query ini alhamdulilah enteng

hemh,, bisa tidur nyenyak

spiderbooo

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 430
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #45 on: March 16, 2011, 08:02:12 PM »
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

  • Reseller OtomaX
  • Full Member
  • ***
  • Posts: 506
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #46 on: April 08, 2011, 09:28:54 AM »
Wediann....muanteb bosss...kerasa banget bedanya...biasanya search trx lambat gila..sekarang lancar...mantap jaya...

Unitedtronik
selamat dan sukses selalu

ipin31444

  • Sr. Member
  • ****
  • Posts: 1,446
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #47 on: April 11, 2011, 10:15:56 AM »
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

  • User OtomaX
  • Full Member
  • ***
  • Posts: 663
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #48 on: February 23, 2012, 03:47:58 AM »
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
Indahnya Kebersamaan Walau jauh Terasa Dekat
SMS/Call : 085357275550 / 081977225999
Telegram : @ircpulsa
powered By otomaX

LUCKY

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 204
  • OTOMAX ENTERPRISE
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #49 on: March 08, 2012, 03:43:37 AM »
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

  • User OtomaX
  • Full Member
  • ***
  • Posts: 795
  • *alskapulsa*
    • Alaska Pulsa
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #50 on: December 27, 2012, 09:27:57 AM »
all tq beud  ;D
add telegram cs : @csalaska21
http://www.alaskapulsa.com
MENGATASI MASALAH TANPA SOLUSI

PulsaHP.com

  • User OtomaX
  • Full Member
  • ***
  • Posts: 721
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #51 on: June 02, 2015, 06:27:04 AM »
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
PulsaHP.com
Samarinda kalimantan Timur