SQL server has a feature called policy-based management which is used to define and also implement policies in SQL server. It is used if we want to apply any policy against a table or database and then checks whether the database or table satisfies with the given policy. If target database objects are not satisfied with the policies then either a trigger should be fired or we can enforce it so that an administrator will come to know that there is some policy violation. It will manage one or more instances of SQL server. Policy-based management provide DBA to create a standard policies, and manage the policies, deploy them, automatically checking the policies.
1. Generally, if we want to find out the when was the last back up has happened then DBA has to make a connection to each instance manually and then check every database individually in order to find the backup dates. So this may require so much of manual work since each instances can have N number of databases may be hundreds of databases. In this …show more content…
DBA is responsible for protecting the integrity of the data by providing the some standard rules. Policy based management used for monitoring and enforce the standard rules as a policy in SQL server.
3. DBA has to protect the configurations made in the system by the unauthorized users. If anyone changes the configuration settings then DBA will not be known that the change has happened in the configuration settings until the users complains about the problem faced because of changes made so this causes a problem. To avoid this DBA can use policy based management which can do the regular checks and make sure that database server are properly configured as we want them to be.
4. Policy based management offers another ability to DBA that it enforces the best practice standards against the databases. Apart from able to create a custom policies we can also use the SQL Server best practice policies which will come default when