In the past we have used Hidden Members for the purpose of having a server which is not used by the transactional application, but used for other purposes like reporting.
This allows you to hammer the hidden reporting member of the cluster with large, even debilitating queries, performing massive and repeated table-scans and sorts which otherwise might negatively impact the transactional DB.
In the past we have used Hidden Members for the purpose of having a server which is not used by the transactional application, but used for other purposes like reporting.
This allows you to hammer the hidden reporting member of the cluster with large, even debilitating queries, performing massive and repeated table-scans and sorts which otherwise might negatively impact the transactional DB.