HP Matrix Operating Environment 7.3 Update 1 Installation and Configuration Guide for Provisioning with Virtual Resources

3. Select Properties.
4. Select Memory in the Server Properties dialog box.
• If Microsoft SQL Server Standard or Enterprise Edition is installed on a separate system, the
Maximum server memory used by SQL Server should be configured to be no larger than
(PhysicalMemory-6GB)
• Whether Microsoft SQL Server Standard or Enterprise Edition is installed on the CMS or on
a separate server, then Maximum Degrees of Parallelism (MAXDOP) should be set as follows:
◦ For servers with 16 or fewer cores, set MAXDOP to 1.
◦ For servers with more than 16 cores, set MAXDOP to 8.
1. Open SQL Server Management Studio.
2. Right-click the SQL Server instance.
3. Select Properties.
4. Select Advanced in the Server Properties dialog box.
If you plan to use a separate Microsoft SQL Server, you need to configure your SQL server
environment to use static TCP/IP ports. To configure TCP/IP ports:
1. Open SQL Server Configuration manager and expand SQL Server Network Configuration.
2. Select Protocols for <your SQL server instance>.
3. In the right-hand screen, right-click TCP/IP and select Properties.
4. In the TCP/IP Properties window, select the IP Addresses tab.
5. Scroll to the bottom of the IP list.
6. Under IPAll
a. Set TCP Dynamic Ports to blank (delete the 0).
b. Set TCP Port to appropriate port (default is 1433)
7. Click OK.
28 Preparing the Central Management Server