It is suspected that she is the corpse behind Artorias' grave (the one where you find her Hornet Ring). She waited with him until she died, or (more likely, as she is probably as long-lived as the other knights) she killed herself at his graveside.