Big Mike, I understand the 3-way compromise. (This might be the only thing I understand) I just may have wrote it wrong on here. I was saying I forgot my speed light, that is why I made my aperture smaller. And I did move my ISO up to 400 but I have a D3100 so I hate to go past that. There just wasn't enough light but I wanted to make sure that I wasn't doing something else wrong. So next time I will make sure to increase my aperture a bit and not forget my sb-800 at home.
In my class, I teach my students not to fall victim to the 'ISO Bias'....and that's exactly what you are doing.
You didn't want to move the ISO higher than 400, so you ended up using too large of an aperture (getting too shallow a DOF).
I'd be very confident that your camera can easily give you very good results at ISO 800 and even 1600....maybe higher with some noise reduction applied in post.
If you have been finding that you do get too much noise at ISO 800, then I'd first want to know how accurate your initial exposures are. If you get good exposure 'in-camera', then ISO 800 should be just fine. But if you underexpose and have to brighten the images in post...then ISO 400 may not be low enough. If you nail your exposure or even go a little brighter (
Expose to the Right) then ISO 1600 would like be acceptable.
Secondly, I'd want to know how you are evaluating your noise levels to determine how much is too much. If you zoom into 300%, you are going to see flaws every time.
You should evaluate noise levels at around 100% zoom and also know that a little noise reduction can go a long way.
Lastly, if you print an image...much of the noise will be erased by the act of spraying ink onto paper.
Lastly (again)...even if you print a large image that has some noise...you have to keep in mind that large prints are meant to be viewed from farther away...and at that point, the viewer won't see the noise anyway.
Long story - short.....don't be so afraid to raise your ISO.