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.