January 7, 2003 at 10:48 am
I have database with 30 Mil recoreds and I want to delete 10 Min records using delete command. average size of the records is 100 bytes. How I can estimate the Transaction log file size I need it to delete all records in one delete command?
Thanks
January 7, 2003 at 11:15 am
I'd first question whether you need to do it in one statement. Can cause an unnecessary load on your server. Do you really need an all or nothing delete?
I'd batch the job in groups to ease the load(http://www.sqlservercentral.com/columnists/sjones/batching.asp). Or delete 100,000 and extrapolate the log size needed. you can run a backup before and after the delete to get an idea of the size.
Steve Jones
January 7, 2003 at 11:18 am
Is ther any formula that will help me calculating the log size?.
Thanks
January 7, 2003 at 11:52 am
Sorry no formual needed. If you are going to delete all records at one time then just do a
TRUNCATE TABLE and it will not log that much.
If you are doing deletes of a few rows think of the row length total and about 100bytes or so extra per row to delete. And over estimate.
Edited by - antares686 on 01/07/2003 11:54:21 AM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply