locked
Overhead of using Central Management Server RRS feed

  • Question

  • 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.
    Saturday, April 28, 2018 4:16 AM

All replies

  • 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

    Saturday, April 28, 2018 4:51 AM