Sati was not at all a dominant societal custom in the Vedic era, nor did it originate from the Vedas. Other major Hindu texts, like the Dharmashastric corpus, which are post-Vedic texts, don't remotely promote Sati.
There are certain questions which need to be answered before discussing about Sati. Was Sati sanctioned and mandated in the religio-legal scripts or texts in ancient India?