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

Ryra Multipay

  • Reseller OtomaX
  • Hero Member
  • *****
  • Posts: 2,261
  • OtomaX Ultimate
    • 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
Telegram: @ryra_official
| www.ryracell.co.id Server Pulsa All Operator & PPOB Online

lintas

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 211
    • 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: 565
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
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: 447
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: 507
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: 664
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

  • Full Member
  • ***
  • Posts: 808
  • *alskapulsa*
    • paket data kuoata murah
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #50 on: December 27, 2012, 09:27:57 AM »
all tq beud  ;D

PulsaHP.com

  • User OtomaX
  • Full Member
  • ***
  • Posts: 725
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

Masterajat

  • User OtomaX
  • Full Member
  • ***
  • Posts: 647
  • SIKUCAPANG SIKUCAPAI
    • www.aeroppob.com
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #52 on: May 02, 2018, 08:55:14 PM »

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
OTOMAX ULTIMATE
www.aeroppob.com
SPESIALIS ANTI CLUSTER

SIKUCAPANG SIKUCAPAI