Sand dams, a popular water harvesting structure employed by rural communities, capture and store water for use during the dry season in arid and semi-arid regions. Most sand dam research has been performed on the "ideal" sand dam, despite approximately 50 % of sand dams not functioning as intended. This research involves a 1-year long, in-depth field study of three sand dams in Tanzania, one of which is essentially non-functioning. The study investigated a sand dam's impact on macroinvertebrate habitat, vegetation, and streambank erosion and explored a sand dam's water loss mechanisms. Surveys of macroinvertebrate assemblage were performed each season. Vegetation surveys were performed every other month, and erosion was recorded semi-monthly. Water table monitoring wells were installed at each sand dam, and measurements were taken twice a day. The study found that sand dams are too homogeneous to provide the sustenance and refugia macroinvertebrates need at different life stages. The non-functioning sand dam has a thick layer of silt preventing infiltration of rainwater. The functioning sand dams store a significant amount of water, but most is lost to evapotranspiration within a few months of the last rainfall. Unlike the non-functioning sand dam, the functioning sand dams have a positive impact on local vegetation and minimal impact on erosion. Sand dams can increase the water security of a community, but site characteristics and construction methods must be strongly considered to maximize the sand dam's positive impact.