Based on your comment, I have updated the table to 'Users' WITH (NOLOCK). Since it is TOP(1) with (NO LOCK) on Key, it should be really quick. And, I prefer Users over other tables because, it covers incomplete imports too. Incomplete imports generally have an empty 'Users' Table. I am guessing import loads the tables alphabetically

This means 2 things. If we are not okay with that, I will change it to GallerySettings instead of Users

1) Primary service's health is still measured correctly with this query. This is good
2) Failover service's health is better measured with this query. But, 'Primary Ops' will likely receive a phone call even for an incomplete import to Failover as against a Failover that is truly fully down. I would like to think that an incomplete import is just as bad as a unavailable DB