Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What is the differences between Central Management Servers and Master Server (MSX) / Targer Server (TSX) concepts in SQL Server? I know that MSX/TSX is related to SQL Agent and the basic idea is to run jobs from MSX on TSX (possibly many), but I thought this is also possible in CMS scenario (by using scheduled stored procedures). Is that so?

share|improve this question
add comment

1 Answer 1

up vote 2 down vote accepted

The MSX/TSX is indeed related to the SQL Agent, allowing you to schedule jobs on a master server and have those jobs pushed out to slave servers.

CMS is an extension on the registered servers concept and allows you register servers into the MSDB database of a single instance through the SSMS GUI. Once the servers are registered in the CMS you can logically group them by business unit, version, etc. Once you have them registered any DBA/user with permission to the instance can connect to the CMS and see the same grouping.

CMS does not allow you to schedule agent jobs like MSX does, but you are able to run a script through SSMS on servers grouped in the same folder in CMS. For example, if you highligh a subfolder in CMS and hit New Query it will connect to all the instances registered in that folder and run the script on each one. Below is an example script you could run; CMS will return the instance name and the user running the script as columns by default. You can also use CMS for grouping Policy Based Management evaluations and policies.

select @@VERSION as Verison

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.