The XenDesktop database contains both configuration and state information, which must be updated often.
A single Virtual Desktop Agent (VDA) inactive for an hour generates approximately 62 kilobytes of transaction log data.
Following are the average transaction log calculations:
Number of Virtual Desktop Agents x 24 Hours x approximately 62 kilobytes of data.
Example 10 VDA Farm in idle state:
10 VDA x 24 x 62K = 14.8 megabytes
Note: This can be substantially higher in active environments.