For anyone interested in the experiences of ordinary soldiers and sailors in this period, I recommend the Life and Adventures of Matthew Bishop (free on archive.org). He served as a tar in the English navy and participated in the descent on Cadiz. Later, he switched to the infantry, and fought in battles like Malplaquet.
There are a handful of other works like his in English, but does anybody know of memoirs or accounts by ordinary soldiers or sailors in French, German, Dutch, Spanish, or other languages?
All the Best,