A Principled Technologies test report 13
Database performance and resiliency in the Intel processor-powered
Dell PowerEdge R630 running Microsoft SQL Server 2014
4. In the Select Servers or a Cluster dialog box, add the server hostnames of the SQL Server instances that you
want to configure as replicas in your Availability Group. Click Next.
5. In the Testing Options dialog box, make sure that the option Run all tests (recommended) is selected. Click
Next.
6. In the Confirmation dialog box, click Next.
7. In the Summary dialog box, click Finish to create the Windows Failover Cluster.
8. In the Access Point for Administering the Cluster dialog box, enter the virtual server name and virtual IP
address of your Windows Server Failover Cluster.
9. In the Confirmation dialog box, click Next. This will create the Windows Failover Cluster using the servers as
nodes of the cluster, and add DNS and Active Directory entries for the cluster hostname.
10. In the Summary dialog box, verify that the configuration is successful.
11. To configure the cluster quorum configuration to use a file share, right-click on the cluster name, select
More Actions and click Configure Cluster Quorum Settings… We will be configuring a file share witness for
our cluster quorum setting. By default, the wizard will configure the cluster to use Node Majority.
12. Click Next.
13. In the Select Quorum Configuration page, select the Add or change the quorum witness option. Click Next.
14. In the Select Quorum Witness page, select the Configure a file share witness (recommended for special
configuration) option. Click Next.
15. In the Configure File Share Witness page, type path of the file share that you want to use in the File Share
Path: text box. Click Next.
16. In the Confirmation page, click Next.
17. In the Summary page, click Finish.
Enable SQL Server 2012 AlwaysOn Availability Groups Feature
1. Open SQL Server Configuration Manager. Double-click the SQL Server (MSSQLSERVER) service to open the
Properties dialog box.
2. In the Properties dialog box, select the AlwaysOn High Availability tab. Check the Enable AlwaysOn
Availability Groups check box. This will prompt you to restart the SQL Server service. Click OK.
3. Restart the SQL Server service.
Create and Configure SQL Server 2012 AlwaysOn Availability Groups
1. Open SQL Server Management Studio. Connect to the SQL Server instance
2. In Object Explorer, expand the AlwaysOn High Availability folder. Right-click the Availability Groups folder
and select the New Availability Group Wizard… option. This will launch the New Availability Group Wizard.
3. In the Introduction page, click Next.
4. In the Specify Availability Group Name page, enter the name of the Availability Group in the Availability
group name: field. Click Next.
5. In the Select Databases page, select the checkbox beside the database that you want to include in your
Availability Group. The databases have to be in Full recovery model prior to joining them in the Availability
group. Click Next.
(19 strony)
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji