I do not have a clear picture of what levels are Ok and what levels are somewhat stressful, only what levels actually kill fish, which are very high.
IMO, there are a lot of opinions on what levels are OK and what levels are not, but most are not backed up by clear supporting evidence.
As to death, here's my commentary from a thread related to Seachem Prime's claim to help with nitrate deaths:
How much needs to be present?
Here's from my most recent nitrate article:
Fish, it seems, are not very sensitive to nitrate. Most researchers find little toxicity13. One group that studied a variety of species of fish larvae report:
“Judging from its effect on 1st-feeding, unionized NH3 is a potential hazard in the rearing tank; NO2– and NO3– are nontoxic at levels likely encountered in practical marine fish culture.”14
Here's a post from a professor who looked into nitrate toxicity:
Reef Central is dedicated to the marine reef aquarium hobby. Learn about reef aquarium setup and maintenance, and view coral and marine fish photos. Visit our online community and discuss and chat with hobbyists of all levels from beginner to advanced.
www.reefcentral.com
Maybe it's an accepted belief, but it's not close to being correct scientifically. And there are a LOT of papers on nitrate toxicity in saltwater from just a quick pubmed search.
The lowest LC-50 I could find for nitrate toxicity in a marine environment (for fish) was over 500 mg NO3-N / L. That is about 2200 ppm NO3.