How much overhead is placed on a production server by using it as a CMS? Are multi-server queries and policy-based management tasks done on the CMS itself or distributed to the target servers? Should I use a low utilization server as
the CMS? Thanks.
CMS servers have there own dedicated instance and they are not installed on production so I hardly see any load that it will create. When you execute a query sql server open connection to all added servers and execute query on that server then bring the rsult
and display in SSMS windows
Cheers,
Shashank
Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it
My TechNet Wiki Articles
MVP
