When we installation or upgrade Sql Server from a previous version into 2008, by default a job will be created
syspolicy_purge_history.
What does it do?
Sql Server 2008 introduced a new feature called Policy Based Management.
For example, one could define a policy that says all tables must have a clustered index.
Once defined, the policy can be evaluated against targets to check for compliance. Each evaluation of compliance will be recorded in below tables :-
1. msdb,
2. syspolicy_policy_execution_history_details_internal,
3. syspolicy_policy_execution_history_internal, and
4. syspolicy_policy_category_subscriptions_internal
The evaluation condition is built on top of object facets, which is predefined by Microsoft.The purpose of that job, syspolicy_purge_history, is to remove records in those tables to maintain so it does take up space unnecessarily.
Happy Readding.
@Sumnjha
What does it do?
Sql Server 2008 introduced a new feature called Policy Based Management. For example, one could define a policy that says all tables must have a clustered index.
Once defined, the policy can be evaluated against targets to check for compliance. Each evaluation of compliance will be recorded in below tables :-
1. msdb,
2. syspolicy_policy_execution_history_details_internal,
3. syspolicy_policy_execution_history_internal, and
4. syspolicy_policy_category_subscriptions_internal
The evaluation condition is built on top of object facets, which is predefined by Microsoft.The purpose of that job, syspolicy_purge_history, is to remove records in those tables to maintain so it does take up space unnecessarily.
Happy Readding.
@Sumnjha
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757