Hi,
The D800 has taught me to be humble - I simply cannot afford the glas that outresolves this sensor.
The good news is you just got the worlds best camera in terms of resolution and dynamic range at ISO 100.
The bad news is that almost none of the lenses available either of Nikon or Zeiss or Sigma or whatever make outresolves this sensor. Most expensive lenses will be far from that target. Cheaper lenses will be even further away.
Meaning any 100% pixel peeping will confirm what? that I just got another lens that is far from outresolving the D800 sensor.
The good news is that I can take sharpening to "100" in Lightroom without getting a lot of artifacts - just remember to mask out the sky!
I got the 70-200mmF4 & the Zeiss 35mmF2 that I consider fit for D800. Today I would probably have preferred the Sigma Art 35mm F1.4. But the diff is tiny on photozone.de. More diff at DxOmark.
Looking at DxOmark.com shows that the excellent 70-200mm F4 or the xx-200mm F2.8 (various versions) stop at around 21 PMpix which is a no doubt contentious measurement of "equivalent resolution". But to me it is a relative measure giving just an idea of relative sharpness nothing more.
Compare to the Nikon 200mm F2.0 AFS VR that scores 28 PMpix. I would expect 28Pmpix to be close to the limit of the D800. Perhaps the D800E pulls a few more PMpix out of that lens - it does in the case of a few other lenses. The resolution cannot be "true" 36Mpix because of the Bayer filter interpolation.
Most great lenses score 13 - 16 PMpix.
APS-C mostly score below 10 PMpix with a few exceptions - Sigma Art being one.
There is no reason why APS-C 24 Mpix bodies should not be able to score closer to 20 than 10 - I guess the good reason might be that CaNikon try to keep lens prices down for APS-C to match their perceived expectations of the smaller format in the market.
Now look up the price and weight of the 200mm F2.0 and know what you have to pay and carry to reach the quality that will allow you to pixel-peep happily at 100%
Use live-view + loupe in your testing to manually focus lenses to truly know what you are focusing at.
Congratulations with your new camera! Have fun!