In medieval Europe alcohol was consumed on a fairly widespread basis. Drunkenness was a recognized problem in writings so its safe to assume that at least to some degree people recognized that moderation was important. That said, the general consensus was that alcohol was beneficial to health and wellbeing. It was even considered medicinal in many forms.

I have not personally come across much in the way of census when it comes to drinking but we have records of how much alcohol was allotted to monks as a daily ration. Benedictine monks and nuns, for example, received a daily ration of about half a pint (sometimes stated as half a quart in some translations) of wine which is a moderate amount.

As for women one of their main domestic duties in northern Europe was to keep the household stocked with the ale that they would personally brew. I've never come across anything that would point to them not enjoying what they brewed themselves. As Europe became more commercial you find many "alewives" who ran large commercial breweries.

In places/classes where you had steady access to wine, white wine seems to have been considered more appropriate to youth and women whereas red wine was more appropriate for men because it was too "hot" within the context of the way the medieval mind viewed health and medicine. At least one writer felt that sweet wines should be avoided by children and young women.

I cant find it after a quick search but I distinctly remember reading how winemakers in Burgundy during the transition period between the middle ages and the early modern era would not share wine at the dinner table with their wives and children but in any case this would probably be an exception to general consumption patterns.

I wanted to mention that you might read that people regularly drank alcohol because water was unsafe to drink. The premise of this is fundamentally incorrect as we have significant records of people from many different areas drinking water. Even in cities where sewage and industrial waste contaminated local water they would engineer large public works to ship fresh water to people. There is just no evidence at all that unclean water was a motivation to drink alcohol. Its a myth that is frequently repeated in "popular histories" and never backed up with evidence.