(SPOILERS AHEAD)
I'm watching Stargate SG-1 again, and one issue that has always bothered me is the way that the Season 7 episode Heroes killed off Dr. Fraiser. After seeing so many other characters revived in various ways over the course of the series, why did the SGC not try to revive Dr. Fraiser too? There would have been many options available: the Nox healing ceremony, finding and using a sarcophagus, possible solutions from allies like the Asgard, something more complicated like time travel, etc. However, they just announce that she's dead at the end of the episode and seem to shrug it off as an inescapable situation without considering past team member resurrections. I have heard fans make the argument that Dr. Fraiser was just not important enough of a figure in the SGC to bother with an attempted resurrection, but I have difficulty believing that the Chief Medical Officer with 7 years of accumulated knowledge on alien life would not be considered essential enough to even consider the possibility of a revival mission.
Is anything relating to why a full-scale resurrection effort was not immediately launched by the SGC explained anywhere else in the shows, movies, or other related media?
And before anyone mentions it, yes, I have read about the network politics and comments by the writers that lead up to the decision to kill Dr. Fraiser permanently. (Don S. Davis is quoted as saying it was a decision made by "some stupid bean counter" in the network management.) I am NOT looking for a "behind-the-scenes" explanation and am specifially looking for in-universe explanations as to why there was seemingly no effort by the SGC to resurrect her.