sqlserver20xxpolicybasedmanagementandmultiserveradministration-資料下載頁(yè)
2024-10-04 13:55本頁(yè)面
【正文】 sing File | Open | Policy allows you to open and edit an existing policy file. Evaluating Policies ?Formerly known as “Run Now” and “Test Policy” (the adhoc policy execution) has been greatly enhanced. You can now run multiple policies at a time. You can run policies stored on any server as well as policies exported to a file. The results of the policy evaluation can be exported as an XML file. Importing Policies ? Policies can now be imported to a group of servers. In addition, the import options have been enhanced to allow preservation of policy settings and the ability to overwrite existing policies. Mar2022 24 Microsoft Developer amp。 Platform Evangelism Policybased Management – Special Features Surface Area Configuration for Analysis Services and Reporting Services ? You can view the facets and evaluate policies when Object Explorer is connected to Analysis Services and Reporting Services. Policies can also be evaluated against Analysis Services and Reporting Services from the Registered Servers tool window. Direct Update of Facet Properties ? Viewing the properties for any facet on any object now allows you to edit the property value through the GUI. Best Practice Policies ? These policies are now installed to the file system rather than in msdb. You’ll find these policies under C:\Program Files\Microsoft SQL Server\100\Tools\Policies\1033 (this location may be different if you install the tools to a custom location). Mar2022 25 Microsoft Developer amp。 Platform Evangelism Policybased Management – Special Features Policy Violation Alerts ? Policy violations will raise an alert and write to the SQL Server error log and the Windows Application log. Using SQL Server Agent Alerts and Database Mail you can receive an notification when policy violations occur. For Alerts, Prevent Policies (Automated): Message ID34050 Check on Schedule (Automated/Ad Hoc): Message ID34052 Check on Change (Automated/Ad Hoc): Message ID34053 Check on Schedule for TSQL and WQL Policies ?The “check on schedule” system has been moved to leverage the new PowerShell Agent Subsystem. This allows for policies referencing conditions with TSQL or WQL expressions to be checked on a schedule. Mar2022 26 Microsoft Developer amp。 Platform Evangelism Mar2022 27 Microsoft Developer amp。 Platform Evangelism
電大資料相關(guān)推薦
鄂ICP備17016276號(hào)-1