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 File Size Set up in Sql 2008
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

poratips
Posting Yak Master

104 Posts

Posted - 08/19/2013 :  14:57:56  Show Profile  Reply with Quote
Hi,
I have to restore DB into New Production server 2008 and we have 2008R2 installed.
I would like to know what will be the ideal setting for Log file set up?

I have Data File, Log File and Temp DB on seperate Disk drive.
I have set up the Data File Initial Size: 100 GB - Growth - 5 GB as total Daat File Drive has 1 TB Capacity.
I am little confused for Log file as We have Replication Subscription will be running on that DB and it will total size of the DB is 300 GB Plus.
Replication will run frequently as well as couple batch job running.
If I set up Log File: 50 GB - Growth - 1 GB as my total Log file drive is configured - 100 GB.

Thanks and appreciate your response!

tkizer
Almighty SQL Goddess

USA
36953 Posts

Posted - 08/19/2013 :  15:55:03  Show Profile  Visit tkizer's Homepage  Reply with Quote
This isn't something we can answer for you as it depends on many factors that you'll need to test. For instance, index rebuilds, replication, large transactions, anything that impacts the tlog.

Some systems can get away with an ldf that's 10% the size of the mdf, others 50%, others 100%, still others over 100%.

So it depends is the answer. You'll need to test.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

poratips
Posting Yak Master

104 Posts

Posted - 08/19/2013 :  18:19:43  Show Profile  Reply with Quote
Thanks Tara.
Our Replication runs frequently, weare not runnign Index Rebuild regularly but planning to run as a weekly job.
If you can give some rough idea to start that will be great.
If I set up Log File: 50 GB - Growth - 1 GB as my total Log file drive is configured - 100 GB, will impact any performance?

Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36953 Posts

Posted - 08/19/2013 :  19:29:05  Show Profile  Visit tkizer's Homepage  Reply with Quote
I can't give a rough estimate. You will need to test it.

The size of the transaction log file doesn't impact performance. The autogrowths will though.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
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.05 seconds. Powered By: Snitz Forums 2000