HP Matrix Operating Environment 7.2 Installation and Configuration Guide for Provisioning with Virtual Resources

◦ Additionally, for large environments, it is recommended that Microsoft SQL Server be
deployed on a separate server.
◦ If you plan to use a separate Microsoft SQL Server, you need to install and prepare your
database server environment before you proceed to the following section.
NOTE: Skip this section if you plan to install SQL Express, included with HP Insight
Management software.
If you plan to use a separate Microsoft SQL Server, configure the model recovery type
to “Simple” prior to the Insight Management installation. You will not have to modify the
database recovery model for multiple components after the installation.
To set the database recovery model:
1. Open SQL Server Management Studio and connect to the appropriate instance of
the Microsoft SQL Server Database Engine.
2. In Object Explorer, click the server name to expand the server tree.
3. Expand Databases, and right-click the model database, and then click Properties to
open the Database Properties dialog box.
4. In the Select a Page pane, click Options.
5. The current recovery model is displayed in the Recovery model list box.
6. Change the recovery model to “Simple.”
7. Repeat the instructions from Step 3 to Step 6for all other databases, including System
databases.
Configuring and tuning Microsoft SQL Server is beyond the scope of this guide. However, consider
the following guidelines:
• If Microsoft SQL Server Standard or Enterprise Edition is installed on the CMS, the Maximum
server memory used by SQL Server should be configured to be no larger than (PhysicalMemory
minus 6 GB) / 2. For example, if the CMS has 32 GB of DRAM, then SQL Server should be
configured to use no more than 13 GB.
To configure the maximum server memory:
1. Open SQL Server management studio.
2. Right click SQL Server instance.
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.
26 Preparing the Central Management Server