SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Log space involved in Index Rebuilding
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sgondesi
Posting Yak Master

India
194 Posts

Posted - 01/23/2014 :  06:09:43  Show Profile  Reply with Quote
Hello everyone..

I read in one site that, an index rebuild requires space greater than or equal to the table on which it is defined and as a . Is that true?

Already log grows when the index was first created right? Why does does it grows again when the index is rebuilt?

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.

tkizer
Almighty SQL Goddess

USA
37133 Posts

Posted - 01/23/2014 :  12:16:27  Show Profile  Visit tkizer's Homepage  Reply with Quote
Yes it's about 100% space of the index in the log file.

It uses log space because it's a transaction. Anything that changes data/structure/etc requires log space. Log space is not the same thing as the data space. Log space is regarding transactions and recovery.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 01/24/2014 :  14:55:11  Show Profile  Reply with Quote
Thank you for your valuable information madam.

--
Thanks and Regards
Srikar Reddy Gondesi,
BTECH-IT 2013 Passed Out,
Trainee for SQL Server Administration,
Miracle Software systems, Inc.
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 01/25/2014 :  15:18:53  Show Profile  Reply with Quote
In case relevant: we run Log Backups every 2 minutes during index rebuild (normally ours are every 10 minutes) because Index Rebuild puts more strain on our Log files than any other activity in our databases. We also only rebuild indexes that are fragmented (rather than "Rebuild all indexes every time" <sigh!>
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000