September 20, 2005 at 1:49 pm
Okay, I'm confused. What kind of commands do I need to run to ensure good performance? Is dbccdbreindex the best weay to rebuild indexes or should I use create index with drop existing? What are the best ways to resolve table and and index fragmentation? I need to make sure that I am getting the best disk performance for our current config. Thanks,
September 20, 2005 at 2:18 pm
Oh man, thats a very broad question.
There is no one answer. And I find that the "Shotgun" approach to reindexing/rebuilding indexes can be problematic to the db administration specially when it bloats your log file to gastronomical sizes.
There is a bunch of reading and analysis that has to be done before you can commit on a strategy. It all depends.
Read articles here:
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
http://www.sql-server-performance.com/performance_introduction.asp
http://www.sql-server-performance.com/rd_index_fragmentation.asp
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply