Transaction Logs and Database size relationship
Hi, I am working on storage requirement projection for next few years and have a question about log/database relationship. If a MBX server generated 50GB per week. How much will it add to the mailstore when the logs are fully committed after consider the impact of database/index overhead? Retention is set to 60 days without single-item-recovery. thanks
February 7th, 2012 11:55pm

Hi, You can use Exchange2010 calculator for understanding disk spaceExchange Queries
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2012 2:22am

Hi The transaction log files are a record of every transaction performed by the database engine. All transactions are written to the log first, and then lazily written to the database. Unlike Exchange Server 2003, the transaction log files in Exchange 2010 have been reduced in size from 5 MB to 1 MB. This change was made to support the continuous replication features and to minimize the amount of data loss if primary storage fails. You can use the following table to estimate the number of transaction logs that are generated on an Exchange 2010 Mailbox server where the average message size is 75 KB. The value for Number of transaction logs generated per day is based on the message profile selected and the average message size. It indicates how many transaction logs will be generated per mailbox per day. The log generation numbers per message profile account for: Message size impact Amount of data sent/received Database health maintenance operations Records Management operations Data stored in a mailbox that is not a message (tasks, local calendar appointments, contacts) Forced log rollover (a mechanism that periodically closes the current transaction log file) Terence Yu TechNet Community Support
February 8th, 2012 9:16pm

Number of transaction logs generated per mailbox profile Message profile (75 KB average message size) Number of transaction logs generated per day 50 10 100 20 150 30 200 40 250 50 300 60 350 70 400 80 450 90 500 100 Terence Yu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2012 9:18pm

You can use the following guidelines to understand how message size affects the generation rate of transaction logs: If the average message size doubles to 150 KB, the logs generated per mailbox increases by a factor of 1.9. This number represents the percentage of the database that contains the attachments and message tables (message bodies and attachments). Thereafter, as message size doubles beyond 150 KB, the log generation rate per mailbox also doubles, increasing from 1.9 to 3.8. For example, if you have a 100 messages per day and: An average message size of 150 KB, the logs generated per mailbox are 20 1.9 = 38. An average message size of 300 KB, the logs generated per mailbox are 20 3.8 = 76. The following sections discuss factors that affect your log sizing capacity: Backup and restore factors Move mailbox operations Log growth overhead High availability factors LUN capacity planning Understanding Mailbox Database and Log Capacity Factors If you need example, you can read this example. Exchange 2010 Mailbox Server Role Design Example Terence Yu TechNet Community Support
February 8th, 2012 9:19pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics