Friday, 21 June 2013

SQL Server 2012 Policy Management

Policy management: How to create a new policy


  • Open SSMS and connect to the desired server with the account which has SysAdmin Privileges
  • navigate to policies as shown below



  • Right click on policies and click New policy..
    1. Fill the policy Name field
    2. In check condition select new condition… which will take you to a new window as shown in the figure below


  • Fill the following fields according to the below table



#
Policy name
Settings
1
Authentication
*
2
Backup compression
*
3
MAXDOP
*
4
Maximum Memory
*


Step 2: Procedure to evaluate the policy on a single server


  • Right click on the desired policy and click on Evaluate as shown below
  • Immediately you will get the result window, which looks like the below image where you can see the policy is passed or not. You can see the details as well



  • Procedure to evaluate a policy on multiple servers


  • Open SSMS, go to view and click on Registered Servers, you will get new window to register more servers



  • Right click on Local Server Groups and click on New Server Registration and enter the respective name and click save


  • Repeat the above step till you add all the desired servers


  • Right click on the server group and click on Evaluate Policies


  • Select the source machine where the policies are configured



  • It will show the complete list of policies available, select the desired policies and click Evaluate



  • It will provide output as shown below, where you can export the results



1 comment:

  1. There is noticeably much to experience this. I believe you made several well points in Features as well. http://www.lowhosting.com/justhost-review/

    ReplyDelete