5 Sep

Best Practice No.36

Sarabpreet Singh Anand Best Practices Leave a comment

Do proper capacity planning for the growth of your Transaction log file and size them accordingly – don’t leave it to Auto-grow on default setting to avoid performance hit.

Transaction Log files cannot take advantage of Instant File Initialization.

Related posts:

  1. SQL Tip-3 | Don’t Shrink your Database
  2. Best Practice No.5
  3. Best Practice No.6
  4. Best Practice No.11
  5. Best Practice No.25

About Author:

SQLServer - MVP Sarabpreet is SQLServer MVP, Consultant, Speaker, Trainer, Blogger and Community Lead. You can find him speaking at a local UG Event or a SQL Webcast. He has 11+ years of Experience and worked with Industry Leaders. He has many SQL Certifications under his belt. His core competency lies in administration of SQL Server. Always ready to help, online \offline. His life’s mantra is “Knowledge Increases by sharing so, Pass it on”.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.