February 28, 2009 at 1:19 pm
Hi All,
Can anyone please let me know what are the design criteria for Transaction
log files?!
Lets say If I have 2 database -
one with 10GB database
Another one with 1TB database...
How to go about designing log files in above scenario...
Thanks in Advance ....
Prabha
February 28, 2009 at 3:30 pm
i assume you mean what are the ideal sizes for the log files?
the answer is how much activity is created against the database?
start off with 10% of database filesize for the log and increase as necessary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2009 at 12:00 am
and also Set your transaction log file size to the maximum value that it can grow. I would advise you to monitor the Tlog growth/day basis.
I would also recommend you to place Tlog file on a separate drive. What is your hardware configuration? Did you think about it?
Do not set your Tlog file to autogrowth as this might degrade performance. Did you identify your business requirements? Do you need point in time recovery, if so inquire the loss of data factor within your business and set your Tlog backups accordingly.
Make sure you have enough space on the drive for your Tlog for daily maintenance tasks ex: Bulk loading, Index Rebuilding etc..
I hope these will give you an idea.
Cheers!!
March 1, 2009 at 3:41 am
Krishna (3/1/2009)
Index Rebuilding etc..
you probably don't want to be\shouldn't nedd to be doing this daily
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2009 at 5:28 am
Perry Whittle (3/1/2009)
Krishna (3/1/2009)
Index Rebuilding etc..you probably don't want to be\shouldn't nedd to be doing this daily
oops my mistake:P....meant to say maintenance tasks not daily, sometimes you would have to drop and rebuild in the staging tables of datawarehouse depending on the fragmentation levels. but its purely dependent on application.:)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply