Estimating suitable log file size (MSSQL Server)
Posted on 2012-08-15
I have an application that uses MS SQL Server. The application does not uses transactions explicitly but as I understand, applications create or use default transactions. The fact is, that the log file is growing and I need to reduce it. The client is asking me to recommend a minumum log file size suitable for the application but I have no idea how to calculate such size, based on how my program works. So my question would be:
How do you calculate the espace needed for an application, regarding the log size (MS SQL Server) based on the instructions you send to the database (inserts, updates, etc)?
Note: as I don´t use explicit transactions that log information is useless for my application.
Thank you in advance.