Just for a little more information, it looks like SameSubnetDelay and SameSubnetThreshold are two additional settings that affect the sensitivity of a failover (https://blogs.msdn.microsoft.com/clustering/2012/11/21/tuning-failover-cluster-network-thresholds/).

With so many areas...

Ok, just because this has really been enlightening and I'm curious to know more, let me throw this out there.

If the strategy is to run checkdb before the...

Actually, based on what you said, I suppose it could also go like this:

full backup on primary, checkdb (physical only) on primary, stats/index maintenance on primary......restore the database to...

Everyone,

Thank you so much for the feedback--it's incredibly helpful. One more question, only because I'm finding conflicting views. When it comes to index maintenance, would you personally do...

Gail,

Thanks for clarifying the Node2 thing.

Regarding this:

As I said earlier, restoring the weekly backup every day and running checkDB is completely pointless. If...

Gail,

Thank you. I've taken into account all of the advice. Would you mind taking a quick look to see if you notice anything I'm missing (or doing that I shouldn't...

I think I get it now. Based on what you've all said, does this sound reasonable:

NODE1 (primary), NODE2 (secondary), NPS1 (non-production server)

- Weekly: run checkdb (physical_only)...