alanspeckman (9/30/2013)
While keeping one witness for one production database instance makes sense to me, why on earth would I want one witness for multiple DB instances?
Why wouldn't you? Witness has no data, the role adds just about no load. All it is is an instance that provides quorum in the case of a failure of one of the other nodes. Doesn't make sense to install multiple SQL instances just to sit there and do just about nothing.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability