XenDesktop 7 calculation of SQL mirror transaction log growth

There are several ways to calculate the growth of its transaction log:

• DDC Heartbeat Service Information

• Site Heartbeat Service Information

• Virtual Machine Work Heartbeat service Information

DDC Heartbeat Service Information

each one the DDC server in XD7 has a heartbeat connection of ten Windowsservice every three seconds to prove that the DDC The server is also active and running.

each heartbeat is 606 bytes, so each DDC 's heartbeat byte is 6060bytes, one hours is a heartbeat, then each DDC The one-hour heartbeat byte is 727200 bytes.

Site Heartbeat Service Information

There is a user's logon request, etc. session information is made by a single DDC for processing, so the bytes generated by this separate site service do not generate double copies, which we calculate separately here;

Monitor:6 Site Services = 384 Header + 6 * 1524 = bytes

Delegated admin:1 Site service = 384 header+ 1* = 574 bytes

BROKER:16 Site Services = 384 Header + *190 = 3424 bytes

Hosting:1 Site Service = 384 + 574bytes

Desktop Update manager:1 Site service = 384+ = 574 bytes

Config logging:2 Site Services = 384 +2*190 = 764 bytes

AD identity:1 Site Service = 384 + =574 bytes

from this we can calculate, once Site Service Request consumes the heartbeat is 8008 bytes, then every one hours is 960960 bytes,

Virtual Machine Work Heartbeat service Information

for XD7 's 2 mode (HSD and HVD), each VM's working heartbeat is every 5 minutes, the heartbeat size is 1150bytes, Each working heartbeat is about 13800 bytes for one hours .

To sum up, let's summarize

the number of DDC Heartbeat =DDC is multiplied by 727200 bytes;

site Heartbeat =960960bytes;

Virtual machine working heartbeat = number of virtual machines multiplied by 13800 bytes;

therefore total idle increment ="DDC Heartbeat"+"site Heartbeat"+"virtual machine working Heartbeat"

For example, for a VDI environment with a 10000 VM, there are 2 DDC, the lowest growth will be:

DDC Heartbeat =2*727200 bytes =1454400 bytes

site Heartbeat =960960 bytes

Virtual machine working heartbeat =10000*13800 bytes =138000000 bytes

Hourly Total idle growth =1454400+960960+138000000=140415360 bytes or =134mb per hour

so daily growth 3.2GB .

English Original:

http://blogs.citrix.com/2014/05/16/xendesktop-sql-transaction-log-usage/?utm_source=feedburner&utm_medium= Feed&utm_campaign=feed%3a+citrixblogs+%28citrix+blogs%29

This article from the "I Take fleeting chaos" blog, please be sure to keep this source http://tasnrh.blog.51cto.com/4141731/1435196