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 |
|
Analyzer
Posting Yak Master
115 Posts |
 Posted - 2007-11-20 : 06:02:12
|
| I need to manage the problem of negative performance implications when I fragment a 1TB+ DB. I want to perform Index Reorganization if fragmentation is no higher than 30%, and Index Rebuild if the fragmentation exceeds 30%. Firstly can anyone recommend a script which uses sys.dm_db_index_physical_stats system to ascertain thefragmentation level. Secondly, is there a technique I can employ to prevent the ONLINE operation completely killing performance on 27/4 production system? ALTER INDEX REORGANIZE/REBUILD WITH (ONLINE=ON) |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-11-20 : 12:25:08
|
quote:
Originally posted by Analyzer
Secondly, is there a technique I can employ to prevent the ONLINE operation completely killing performance on 27/4 production system? ALTER INDEX REORGANIZE/REBUILD WITH (ONLINE=ON)
By default the feature is OFF. So unless you specify the ONLINE=ON condition, online reindexing doesnt happen.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
stephe40
Posting Yak Master
218 Posts |
Posted - 2007-11-20 : 12:43:28
|
| http://weblogs.sqlteam.com/tarad/archive/2007/04/17/60176.aspx- Eric |
|
|
|
|
|
|
Index Fragmentation Strategy for VLDB