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

red_dr4gon7

  • 0856 4002 8008
  • User OtomaX --
  • Sr. Member
  • ****
  • Posts: 1,782
  • < ".RAZIA." >
    • Software Isi Pulsa
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #20 on: June 26, 2010, 11:38:13 PM »
Ya iyalah.. Wong nama database nya aja gak dirubah gmn mau eksekusi, hahaha..  ;D  :D

zurigh

  • Jr. Member
  • **
  • Posts: 346
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #21 on: June 26, 2010, 11:57:15 PM »
tutornya gmn gan ??? ???
yg luengkap biar yg gaptek ky sy bs coba  :D :D

H2H MURAH TRX Wushh..Wushh..
OtomaX : Versi Tiket
OID : ORI
Backup inet & PLN : Hadirr
CS Ready 08:00 s/d 22:00 NO BISU NO OFFLINE

AE_Reload

  • User OtomaX
  • Sr. Member
  • ****
  • Posts: 1,254
  • SMS/WA:087771191777
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #22 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

fadlyfayruz

  • User OtomaX
  • Full Member
  • ***
  • Posts: 703
  • Tukeran stok H2H yuk :)
    • DFlash pulsa
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #23 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

farhancellular

  • User OtomaX --
  • Full Member
  • ***
  • Posts: 529
  • pusat grosir pulsa all operator
    • pusat grosir pulsa all operator
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #24 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???
support by:
Otomax Advanced+otomax standart 10terminal
OID: c0d59f87f5ccae5d68847190c4712e9b
OID: c9a5c46c20d1070054c47dcf4c5eaf00
http://www.farhancellular.com

deydi

  • User OtomaX --
  • Sr. Member
  • ****
  • Posts: 1,271
  • pm
    • Pasang Iklan Baris GRATIS
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #25 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?
http://www.dmtronik.com
http://www.manadowebhost.com
YM : dmtronik_cs, cs_dmtronik, otomax_manado

Yusuf

  • Administrator
  • Sr. Member
  • ****
  • Posts: 1,281
    • Orisinil.com
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #26 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.
« Last Edit: June 28, 2010, 01:17:28 PM by Yusuf »

centerpulsa

  • User OtomaX
  • Full Member
  • ***
  • Posts: 773
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #27 on: June 28, 2010, 11:41:21 AM »
SAYA uda coba seperti nya mmg agak cepat pada saat membuka otomax nya,hihihihi
OTOMAX ULTIMATE 3.6.2 (server Utama)                   IRS V6 sbagai Gudang Stok (server pendukung)
@Intel Core i7-4770 CPU@3,40GHz
SSD 120GB, (RAM) 8 GB Win7 64-bit
BB: 2A78ABA4, YM: center_pulsamurah
www.center-pulsa.com

zurigh

  • Jr. Member
  • **
  • Posts: 346
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #28 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  :-* :-*

H2H MURAH TRX Wushh..Wushh..
OtomaX : Versi Tiket
OID : ORI
Backup inet & PLN : Hadirr
CS Ready 08:00 s/d 22:00 NO BISU NO OFFLINE

zurigh

  • Jr. Member
  • **
  • Posts: 346
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #29 on: June 30, 2010, 11:45:53 PM »
MANTAB berasa banget .....
thxs big boss

yg paling berasa dimana nya gan ??? ??? ;D ;D

H2H MURAH TRX Wushh..Wushh..
OtomaX : Versi Tiket
OID : ORI
Backup inet & PLN : Hadirr
CS Ready 08:00 s/d 22:00 NO BISU NO OFFLINE

spiderbooo

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 430
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #30 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..?

zurigh

  • Jr. Member
  • **
  • Posts: 346
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #31 on: July 04, 2010, 01:25:18 AM »
ayooo siapa yg bisa kasi tau yg paling berasa di bagian yg mana ;D :D :D

H2H MURAH TRX Wushh..Wushh..
OtomaX : Versi Tiket
OID : ORI
Backup inet & PLN : Hadirr
CS Ready 08:00 s/d 22:00 NO BISU NO OFFLINE

VIOLET CELLULAR

  • User OtomaX
  • Full Member
  • ***
  • Posts: 716
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #32 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

08993901777-085232250921
Id LINE v10let

zurigh

  • Jr. Member
  • **
  • Posts: 346
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #33 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

H2H MURAH TRX Wushh..Wushh..
OtomaX : Versi Tiket
OID : ORI
Backup inet & PLN : Hadirr
CS Ready 08:00 s/d 22:00 NO BISU NO OFFLINE

Yusuf

  • Administrator
  • Sr. Member
  • ****
  • Posts: 1,281
    • Orisinil.com
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #34 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...

zurigh

  • Jr. Member
  • **
  • Posts: 346
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #35 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  ???

H2H MURAH TRX Wushh..Wushh..
OtomaX : Versi Tiket
OID : ORI
Backup inet & PLN : Hadirr
CS Ready 08:00 s/d 22:00 NO BISU NO OFFLINE

titanium_ponsel

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 247
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #36 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.

BOMB

  • User OtomaX
  • Jr. Member
  • **
  • Posts: 364
  • 3.7.4
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #37 on: October 31, 2010, 06:41:21 AM »
benar2 terasa jd cepat aksesnya
SEMAKIN DIDEPAN

falcon

  • Sr. Member
  • ****
  • Posts: 1,393
  • Lu' Luul Qomariyah
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #38 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............ ??? ??? ???
« Last Edit: December 20, 2010, 09:29:07 PM by falcon »
FFmax KOMPUTER
Jl. Raya Karangsuko 28 Pagelaran Kab. Malang
Tlp: 081555848666, 081334888555 PIN 265DE8E5
OTOMAX SUPORT

epro reload

  • User OtomaX
  • Full Member
  • ***
  • Posts: 700
  • ===Selalu Ada Jalan Buat Yang Berusaha===
    • [move]R2 RELOAD [/move]
Re: SQL Server Performance Tips: Rebuilding Indexes
« Reply #39 on: December 20, 2010, 10:20:22 PM »
Nyimak aj aahh... db ku masih dikit.... belom banyak kaya konco2 disini.... jadi malu... :-\ :-\ :-\ :-\
Office : Jl.Bungur 2 No.44B Rt 10 Rw 06, Jak-tim
Distro : Kp. Raganis, Cintamanik Bogor
WA : 0857-7595-3527