Facets are database objects or server and other, such as a table, a stored procedure, a login and many more. Each facet has a set of properties on which the conditions can be created. In this article I will explain how to view facets in SQL Server.Overview
A Policy-Based Management facet is a set of logical properties that are related to an area of management interest. SQL Server includes several predefined facets. For example, the Surface Area Configuration facet defines, as properties, the features that are off by default.
1. Open Management Studio, start by connecting to the server.
2. In Object Explorer, right-click an instance of SQL Server, instance object, database, or database object, and then click Facets.
3. In this dialog box, you will have access to view the facets of the item selected. Click “Ok” once you are done with the facet configuration:
4. In this dialog you will see the following options:
- Facet: The name of the currently selected facet.
- Description: Provides a general description of the facet.
- Facet properties: Displays the names and settings of the facet properties.
- Export Current State as Policy: Click to export the described state of the facet properties as a new policy in an XML file.
What are the uses for the facets?
Facets allows you to implement one or more management facets. Facets can be configured in one instance of SQL Server, copy the state of the facet in a local file, and import the file into another instance of SQL Server as a management policy.
This concludes View facets in SQL Server.