Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2007-11-28 : 05:57:33
|
| Hi,To improve performance in sql 2000 server i did dbcc reindex after one year.. it shows great improvement in performance.Just one week before i did dbcc reindex, we need to test again because two days entry was not there due to thanks giving day,doing again reindex within one week will affect performance ??? |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-28 : 06:06:24
|
| depends how much your indexes have fragmented in that time really. have you run dbcc showcontig?Em |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-28 : 06:06:43
|
| reindexing should be done when your indexed are fragmented.index fragmentation can be seen with the use of dbcc showcontigreindexing once a week is always a good thing... however this depends on your setup etc..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2007-11-29 : 03:27:31
|
| "reindexing once a week is always a good thing... "This is expected reply ...Ya i saw showcontig.. Can you have any perfect document which explain about terms in showcontig and how it shud be for better performance. |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2007-11-29 : 03:34:05
|
| the explanation of showcontig in BOL is really very goodEm |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-29 : 05:20:09
|
quote:
Originally posted by niranjankumark
"reindexing once a week is always a good thing... "This is expected reply ...Ya i saw showcontig.. Can you have any perfect document which explain about terms in showcontig and how it shud be for better performance.
so the unexpected reply would probably be:nah reindexing is a completly useless thing since the clustered index takes care of it's health by itself. so you can't do anything to improve your performance  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
dewacorp.alliances
452 Posts |
Posted - 2007-11-30 : 02:33:12
|
| I prefer to index defrag instead of reindexing due to locking stuff. |
|
|
|
niranjankumark
Posting Yak Master
164 Posts |
Posted - 2007-11-30 : 03:09:06
|
| "the explanation of showcontig in BOL is really very good"send me the link pls |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-30 : 03:21:07
|
| Need link of boos online? It's on your sql machine. |
|
|
|
|
|
|
dbcc reindex