We have an SQL Server 2000 with one 138GB database currently used. I am worry of the performance because as time goes it becomes slower and slower. So I tried googling out the solution and I found out the DBCC Reindex command. As what I read, first you have to know if the table is really fragmented so you have to use DBCC SHOWCONTIG to know it.
First step I make is: DBCC SHOWCONTIG ('tablename') WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS
step 2: DBCC DBREINDEX ('dtrf') WITH NO_INFOMSGS
step 3: DBCC SHOWCONTIG ('dtrf') WITH FAST, TABLERESULTS, ALL_INDEXES, NO_INFOMSGS
but when I compare the results of dbcc showcontig there is one index that doesn't change anything with greater value of logicalfragmentation.
I attached a jpg file to understand the result well as I am not really good in english words construction.
Question is: Is it normal result or is theres something wrong with it?
Hope somebody can help me..