October 13, 2009 at 12:56 am
Dear all,
how to tune DBCC DBREINDEX when data is getting large ?
thank's
October 13, 2009 at 1:08 am
ipan_nugraha (10/13/2009)
Dear all,how to tune DBCC DBREINDEX when data is getting large ?
thank's
Not exactly sure what the question is, can you give more details?
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 13, 2009 at 1:35 am
i mean when i execute DBCC DBREINDEX it tooks 2 hour, table contain 4.000.000 row.
October 13, 2009 at 2:27 am
ipan_nugraha (10/13/2009)
i mean when i execute DBCC DBREINDEX it tooks 2 hour, table contain 4.000.000 row.
Not sure what I can suggest here, you are rebuilding the index. I could suggest that you use the
ALTER INDEX
instead of DBCC DBREINDEX
if your tempdb database is on a different set of disks to the user database, you could use the
SORT_IN_TEMPDB option
which will reduce the time the index takes to get rebuilt but it will increase the amount of disk space that is used.
another thing to bear in mind is
The rebuild operation can be minimally logged if the database recovery model is set to either bulk-logged or simple
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 13, 2009 at 3:19 am
Don't rebuild indexes that don't need rebuilding. There are lots of custom index rebuild scripts available. There's one I quite like here - http://www.sqlfool.com
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply