The XenDesktop database contains both configuration and state information, which must be updated often. A single Virtual Desktop Agent doing nothing for an hour generates approximately 62 kilobytes of transaction log data.
The following are the average transaction log calculations:
Number of Virtual Desktop Agents x 24 Hours x approximately 62 kilobytes of data.
For example, if we have 10 Virtual Desktop Agent in idle state:
10 VDA x 24 hrs x 62K = 14.8 megabytes per day
Note: This can be substantially higher in active environments.