Đang chuẩn bị liên kết để tải về tài liệu:
Pro SQL Server 2008 Policy-Based Management- P4

Tham khảo tài liệu 'pro sql server 2008 policy-based management- p4', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | CHAPTER 6 POLICY-BASED MANAGEMENT INTERNALS Note You can also enable and disable Policy-Based Management from the context menu that appears when you right-click the Policy Management node. HistoryRetentionInDays Specifies the number of days the server keeps policy evaluation history in its tables. By default this option is set to 0 which means historical evaluation data is not automatically removed from the table in the msdb database. You may want to change the value for this property to retain history for a reasonable length of time such as 30 days in order to avoid unnecessarily bloating the size of the msdb database. However your auditing requirements may dictate the amount of history you need to retain. The cleanup job is handled by a scheduled job under the SQL Server Agent called syspolicy_purge_history which runs every day at 2 00 AM by default. This cleanup job is created automatically when you install SQL Server 2008. LogOnSuccess Specifies whether Policy-Based Management logs successful policy evaluations. By default only failed evaluations are logged to the syspolicy_policy_execution_history_details_internal table. Logging successful evaluations can be useful if you are doing any reporting on the current state of a policy. If only failed evaluations are logged you will not know if the policy is still in a failed state or if it has met the requirements in a subsequent evaluation. Alternatively you can query the syspolicy_configuration view in the msdb database to determine your currently configured values using the query in Listing 6-1. Listing 6-1. Query to determine the current property settings for Policy-Based Management SELECT CAST serverproperty N Servername AS sysname AS Name CAST SELECT current_value FROM msdb.dbo.syspolicy_configuration WHERE name Enabled AS bit AS Enabled CAST SELECT current_value FROM msdb.dbo.syspolicy_configuration WHERE name HistoryRetentionInDays AS int AS HistoryRetentionInDays CAST SELECT current_value FROM .