Forum Orisinil

OtomaX - Orisinil Topup Machine => Tips dan Trik => Topic started by: Yusuf on June 21, 2010, 09:32:24 AM

Title: SQL Server Performance Tips: Rebuilding Indexes
Post by: Yusuf on June 21, 2010, 09:32:24 AM
Periodically (daily, weekly, or monthly) perform a database reorganization on all the indexes on all the tables in your database. This will rebuild the indexes so that the data is no longer fragmented. Fragmented data can cause SQL Server to perform unnecessary data reads, slowing down SQL Server's performance. It will also update column statistics.

If you do a reorganization on a table with a clustered index, any non-clustered indexes on that same table will automatically be rebuilt.

Database reorganizations can be done using the Maintenance Wizard, or by running your own custom script via the SQL Server Agent (see below).

The DBCC DBREINDEX command will not automatically rebuild all of the indexes on all the tables in a database; it can only work on one table at a time. But if you run the following script, you can index all the tables in a database with ease:

--Script to automatically reindex all tables in a database

Code: [Select]
USE otomax --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',95)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

The script will automatically reindex every index in every table of any database you select, and provide a fill factor of 95%. You can substitute any number appropriate for the fill factor in the above script.

When DBCC DBREINDEX is used to rebuild indexes, keep in mind that as the indexes on a specific table are being rebuilt, that the table becomes unavailable for use by your users.

For example, when a non-clustered index is rebuilt, a shared table lock is put on the table, preventing all but SELECT operations to be performed on it. When a clustered index is rebuilt, an exclusive table lock is put on the table, preventing any table access by your users. Because of this, you should only run this command when users don't need access to the tables being reorganized. [7.0, 2000, 2005] Updated 7-24-2006

sumber: http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: AE_Reload on June 21, 2010, 10:23:23 AM
ora ngerti bos  ;D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: Budi Santoso on June 21, 2010, 02:44:44 PM
Maksud nya gmn...

Babar Blas gak Mudeng Bahasa Inggris...  :'( :'( :'( :'( :'( :'( :'(

di translate Keluarnya gini...
Quote
Berkala (harian, mingguan, atau bulanan) melakukan reorganisasi database pada semua indeks pada semua tabel dalam database Anda. Hal ini akan membangun kembali indeks sehingga data tidak lagi terfragmentasi. Terfragmentasi data dapat menyebabkan SQL Server untuk melakukan data yang tidak perlu dibaca, memperlambat kinerja SQL server. Hal ini juga akan memperbarui kolom statistik.

Jika Anda melakukan reorganisasi di atas meja dengan clustered index, setiap non-clustered indexes pada tabel yang sama secara otomatis akan dibangun kembali.

Database reorganisasi dapat dilakukan dengan menggunakan Wizard Pemeliharaan, atau dengan menjalankan script kustom Anda sendiri melalui SQL Server Agen (lihat di bawah).

Perintah DBCC DBREINDEX tidak akan secara otomatis membangun kembali semua indeks pada semua tabel dalam database, hanya dapat bekerja pada satu meja pada suatu waktu. Tapi jika Anda menjalankan script berikut, Anda dapat mengindeks semua tabel dalam database dengan mudah:


Script secara otomatis akan Isi nama baru kotak setiap indeks dalam setiap tabel database yang Anda pilih, dan memberikan faktor isi dari 90%. Anda dapat mengganti sejumlah faktor yang tepat untuk mengisi naskah di atas.

Ketika DBCC DBREINDEX digunakan untuk membangun kembali indeks, perlu diingat bahwa sebagai indeks pada tabel tertentu sedang dibangun kembali, bahwa meja menjadi tidak tersedia untuk digunakan oleh pengguna Anda.

Sebagai contoh, ketika indeks non-clustered ini dibangun kembali, meja bersama kunci diletakkan di atas meja, mencegah semua tapi operasi SELECT untuk dilakukan di atasnya. Ketika sebuah clustered index ini dibangun kembali, kunci meja eksklusif disimpan di meja, meja mencegah akses oleh pengguna Anda. Karena itu, Anda hanya perlu menjalankan perintah ini ketika pengguna tidak memerlukan akses ke meja yang ditata kembali. [7,0, 2000, 2005] Diperbarui 2006/07/24
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: zetha on June 21, 2010, 11:01:21 PM
Periodically (daily, weekly, or monthly) perform a database reorganization on all the indexes on all the tables in your database. This will rebuild the indexes so that the data is no longer fragmented. Fragmented data can cause SQL Server to perform unnecessary data reads, slowing down SQL Server's performance. It will also update column statistics.

If you do a reorganization on a table with a clustered index, any non-clustered indexes on that same table will automatically be rebuilt.

Database reorganizations can be done using the Maintenance Wizard, or by running your own custom script via the SQL Server Agent (see below).

The DBCC DBREINDEX command will not automatically rebuild all of the indexes on all the tables in a database; it can only work on one table at a time. But if you run the following script, you can index all the tables in a database with ease:

--Script to automatically reindex all tables in a database

Code: [Select]
USE DatabaseName --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

The script will automatically reindex every index in every table of any database you select, and provide a fill factor of 90%. You can substitute any number appropriate for the fill factor in the above script.

When DBCC DBREINDEX is used to rebuild indexes, keep in mind that as the indexes on a specific table are being rebuilt, that the table becomes unavailable for use by your users.

For example, when a non-clustered index is rebuilt, a shared table lock is put on the table, preventing all but SELECT operations to be performed on it. When a clustered index is rebuilt, an exclusive table lock is put on the table, preventing any table access by your users. Because of this, you should only run this command when users don't need access to the tables being reorganized. [7.0, 2000, 2005] Updated 7-24-2006

sumber: http://www.sql-server-performance.com/tips/rebuilding_indexes_p1.aspx

solusi http://forum.orisinil.com/index.php?topic=1546.0, setelah berbulan2 pake otomax br x ini ngalamin yg aneh, tapi langsung beres, trims big bozz :-* tapi lbh enaknya dijelaskan maksud dan tujuan script ini biar lbh di mengerti oleh org awam seperti saya...
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: mahfud on June 22, 2010, 03:45:42 AM
mungkin bisa membantu nih
http://forum.orisinil.com/index.php?topic=1550.0
makasi
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: Yusuf on June 22, 2010, 08:19:32 AM
Sedikit sharing aja...

Index adalah semacam tabel tambahan dari tabel sesungguhnya. Tujuannya adalah untuk mempercepat query pencarian data.

Karena data terus berubah/bertambah, Index ini bisa ter-"fragmented" sehingga menurunkan performance operasi pada tabel tersebut.

Script diatas tujuannya untuk defrag index. Coba bayangkan seperti kita defrag harddisk, kurang lebih sama persis seperti itu...

Pada proses defrag, sebaiknya matikan OtomaX atau program2 lain yang mengakses database tersebut.

Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: deydi on June 22, 2010, 11:42:05 AM
Sedikit sharing aja...

Index adalah semacam tabel tambahan dari tabel sesungguhnya. Tujuannya adalah untuk mempercepat query pencarian data.

Karena data terus berubah/bertambah, Index ini bisa ter-"fragmented" sehingga menurunkan performance operasi pada tabel tersebut.

Script diatas tujuannya untuk defrag index. Coba bayangkan seperti kita defrag harddisk, kurang lebih sama persis seperti itu...

Pada proses defrag, sebaiknya matikan OtomaX atau program2 lain yang mengakses database tersebut.



pak, script diatas ditempatkan dimana?
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: ARCON on June 22, 2010, 05:40:50 PM
gak ngerti blas .....  ;D
make e utk otomax gimana ???   :-[
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: Neo_BjBRefill on June 22, 2010, 06:43:02 PM
Mantap..... big bos.... cara ini bermanfaat banget buat yang sudah bengkak databasenya.....
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: AE_Reload on June 22, 2010, 10:40:39 PM
Cara pake nya gmn ya ??
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: fadlyfayruz on June 24, 2010, 01:51:23 AM
nih aku bikinin file phpnya biar lebih gampang..
jadi tinggal masuk masukin parameter aja  ;D

[attachment deleted by admin]
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: fra on June 24, 2010, 05:36:57 AM
nih aku bikinin file phpnya biar lebih gampang..
jadi tinggal masuk masukin parameter aja  ;D

sedot lagi...  ;)
Tq
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: fadlyfayruz on June 24, 2010, 10:02:42 AM
nih aku bikinin file phpnya biar lebih gampang..
jadi tinggal masuk masukin parameter aja  ;D

sedot lagi...  ;)
Tq
semalem abis tes
pas lagi sepi trx otomax di close, database di backup (buat jaga2)
jalanin file nya deh..
stelah selesai. Tak buka lagi oto nya..
wuihh jadi cepeet...
kerasa banget bedanya..

tested by me ;D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: ARCON on June 24, 2010, 10:23:23 AM
make' nya gimana gan,...  ???   ???   ???
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: RieNDya_MulTiTrX on June 24, 2010, 10:26:04 AM
 ??? ??? ???
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: AE_Reload on June 24, 2010, 10:52:24 AM
 ??? ??? ??? ???
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: ARCON on June 24, 2010, 11:54:09 AM
kasih tutornya dong ..  ;D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: Yusuf on June 24, 2010, 07:09:07 PM
make' nya gimana gan,...  ???   ???   ???

pake sql studio bos. ada klik tombol new query. masukin scriptnya disitu dan execute...
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: VIOLET CELLULAR on June 26, 2010, 10:22:49 PM
MANTAB berasa banget .....
thxs big boss
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: AE_Reload on June 26, 2010, 11:01:20 PM
di sy kok keluar gini y  ??? ??? ???
Msg 911, Level 16, State 1, Line 1
Could not locate entry in sysdatabases for database 'DatabaseName'. No entry found with that name. Make sure that the name is entered correctly.
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: red_dr4gon7 on June 26, 2010, 11:38:13 PM
Ya iyalah.. Wong nama database nya aja gak dirubah gmn mau eksekusi, hahaha..  ;D  :D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: zurigh on June 26, 2010, 11:57:15 PM
tutornya gmn gan ??? ???
yg luengkap biar yg gaptek ky sy bs coba  :D :D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: AE_Reload on June 27, 2010, 12:13:33 AM
Ya iyalah.. Wong nama database nya aja gak dirubah gmn mau eksekusi, hahaha..  ;D  :D
udh di rubah jg sama bos,  ;D ;D

kasih contoh dong
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: fadlyfayruz on June 27, 2010, 12:14:37 AM
tutornya gmn gan ??? ???
yg luengkap biar yg gaptek ky sy bs coba  :D :D
1. buka mssql studionya
2. klik new query di pojok kiri atas.
3. nah copy kode ini

Quote
USE otomax --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

lalu paste di mssql studio..
itu database namenya diganti sesuai nama DB juragan.. (standardnya sih otomax kan? )
lalu klik execute..
tinggal tunggu deh...

NB : Pastikan otomax, webreport (jika ada) pokoknya semua aplikasi yang mengakses database itu (kecuali mssql studio) di close dulu..

Goodluck  ;D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: farhancellular on June 27, 2010, 02:52:49 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.


berhasilkah klo hasilnya begini???
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: deydi on June 27, 2010, 07:41:28 AM
tutornya gmn gan ??? ???
yg luengkap biar yg gaptek ky sy bs coba  :D :D
1. buka mssql studionya
2. klik new query di pojok kiri atas.
3. nah copy kode ini

Quote
USE otomax --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

lalu paste di mssql studio..
itu database namenya diganti sesuai nama DB juragan.. (standardnya sih otomax kan? )
lalu klik execute..
tinggal tunggu deh...

NB : Pastikan otomax, webreport (jika ada) pokoknya semua aplikasi yang mengakses database itu (kecuali mssql studio) di close dulu..

Goodluck  ;D

setelah di coba hasilnya seperti ini :

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.


apakah hasil diatas kita save atau diabaikan saja?
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: Yusuf on June 27, 2010, 09:29:08 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.


berhasilkah klo hasilnya begini???

itu berhasil bos.
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: centerpulsa on June 28, 2010, 11:41:21 AM
SAYA uda coba seperti nya mmg agak cepat pada saat membuka otomax nya,hihihihi
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: zurigh on June 30, 2010, 11:44:12 PM
tutornya gmn gan ??? ???
yg luengkap biar yg gaptek ky sy bs coba  :D :D
1. buka mssql studionya
2. klik new query di pojok kiri atas.
3. nah copy kode ini

Quote
USE otomax --Enter the name of the database you want to reindex

DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor

lalu paste di mssql studio..
itu database namenya diganti sesuai nama DB juragan.. (standardnya sih otomax kan? )
lalu klik execute..
tinggal tunggu deh...

NB : Pastikan otomax, webreport (jika ada) pokoknya semua aplikasi yang mengakses database itu (kecuali mssql studio) di close dulu..

Goodluck  ;D

tinggal testi kalo gini.. hatur tengkyu om bajay  :-* :-*
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: zurigh on June 30, 2010, 11:45:53 PM
MANTAB berasa banget .....
thxs big boss

yg paling berasa dimana nya gan ??? ??? ;D ;D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: spiderbooo on July 03, 2010, 05:23:23 PM
 ;D iya nih bos,yg berasa banget dimananya sih..?
Kl saya,berhubung baru,jd database masih sedikit..waktu blm di rebuilding,ukuran database sekitar 70MB..setelah di rebuilding,kok jadi 90MB ya..?
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: zurigh on July 04, 2010, 01:25:18 AM
ayooo siapa yg bisa kasi tau yg paling berasa di bagian yg mana ;D :D :D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: VIOLET CELLULAR on July 04, 2010, 10:53:52 AM
MANTAB berasa banget .....
thxs big boss

yg paling berasa dimana nya gan ??? ??? ;D ;D
paling bersa klu kita udah diujung tanduk oowwwwwhhhhh sungguh nikmat MANTAB  ;D ;D ;D ;D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: zurigh on July 04, 2010, 10:39:21 PM
MANTAB berasa banget .....
thxs big boss

yg paling berasa dimana nya gan ??? ??? ;D ;D
paling bersa klu kita udah diujung tanduk oowwwwwhhhhh sungguh nikmat MANTAB  ;D ;D ;D ;D

malah bnr2 kesitu jwbanya :D :D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: Yusuf on July 05, 2010, 09:36:42 AM
;D iya nih bos,yg berasa banget dimananya sih..?
Kl saya,berhubung baru,jd database masih sedikit..waktu blm di rebuilding,ukuran database sekitar 70MB..setelah di rebuilding,kok jadi 90MB ya..?

dishrink aja bos... ada menunya di sql studio...
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: zurigh on July 26, 2010, 01:11:38 AM
Quote
dishrink aja bos... ada menunya di sql studio...

kalo di shrink nya di tab menghapus data sama ga  ???
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: titanium_ponsel on July 26, 2010, 02:51:55 AM
kok punya sy respon nya begini ya???

DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The statement has been terminated.
Msg 1105, Level 17, State 2, Line 14
Could not allocate space for object 'dbo.SORT temporary run storage:  458229543075840' 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.
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: BOMB on October 31, 2010, 06:41:21 AM
benar2 terasa jd cepat aksesnya
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: falcon on December 20, 2010, 09:26:40 PM
Untuk melakukan Shrink via SQL
otomax>Tasks>Shrink...    Pada SQL Studio Express ada 2 pilihan Yaitu database sama file dan yang menjadi pertanyaan saya apakah ke-2 pilihan tersebut yg dilakukan apa salah satu aja............ ??? ??? ???
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: epro reload on December 20, 2010, 10:20:22 PM
Nyimak aj aahh... db ku masih dikit.... belom banyak kaya konco2 disini.... jadi malu... :-\ :-\ :-\ :-\
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: Ryra Multipay 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
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: lintas 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...
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: joll on December 27, 2010, 10:45:16 PM
Nunggu screen cara reindex nya maaf newbie ;)
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: abg_dewata86 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)
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: SapiLanang 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
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: spiderbooo 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
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: United Tronik on April 08, 2011, 09:28:54 AM
Wediann....muanteb bosss...kerasa banget bedanya...biasanya search trx lambat gila..sekarang lancar...mantap jaya...

Unitedtronik
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: ipin31444 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.
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: ircpulsa 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
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: LUCKY 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
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: alaska on December 27, 2012, 09:27:57 AM
all tq beud  ;D
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: PulsaHP.com 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
Title: Re: SQL Server Performance Tips: Rebuilding Indexes
Post by: Masterajat 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