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.

I'd like to monitor multiple SQL Server instances.
Something similar to what is described in "Monitor Your SQL Server Linked Server Configurations with Policy Based Management" but instead of using "Linked Servers" facet to employ a "Registered Servers" one.

But there is no "Registered Server" facet.
Why? I'd like to grasp this absence from conceptual p.o.v.? and how to make the same as described in the cited article using registered instead of "linked" servers?

SQL Server 2012 R2, Windows Server 2008 R2

share|improve this question
add comment

3 Answers 3

up vote 3 down vote accepted

There is no such thing as a registered server in SQL Server itself.

Registered Servers can be added into SQL Server Management Studio to simplify managing multiple servers.

Policy Based Management, and facets, cannot be used against Registered Servers since they don't actually exist in the database engine.

share|improve this answer
add comment

Registered servers were a special kind of linked server that was used only for SQL Server replication. It has been removed from the product. You'll probably only see that facet on a SQL 2000 or 2005 server.

share|improve this answer
add comment

You can read more about the Policy Based Management and centralized policy management using a central management server in the SQL Server Policy Based Management – evaluating policies on multiple SQL Server instances online article. It describes how to create the central management server too

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.