HP ESO 2.1 User Guide, Edition 4.0

ManualsBrandsHP ManualsServerHP ProLiant DL980 G7 E7-4870 2.4GHz 10 Core 4p Server

Contents

About This Document.....................................................................................5

Publishing History.....................................................................................................................5

Organization...........................................................................................................................5

1 Introduction...............................................................................................6

Features..................................................................................................................................6

New Features In Release 2.0 and 2.1..........................................................................................6

2 Installing HP ESO.......................................................................................8

Software Requirements..............................................................................................................8

Installing the Software...............................................................................................................8

Uninstalling the Software...........................................................................................................9

Upgrading the Software............................................................................................................9

Silent Installation....................................................................................................................10

3 Using HP ESO..........................................................................................11

Starting System Management Homepage..................................................................................11

Microsoft SQL Server Security Settings.......................................................................................13

Getting Started Pages.............................................................................................................14

Quick Start Guide..............................................................................................................14

Introduction Page...............................................................................................................14

Administrator Session (Admin Session).......................................................................................15

SQL Server Login....................................................................................................................16

Settings Pages........................................................................................................................17

Configuration....................................................................................................................17

Data Collection.............................................................................................................17

Software Discovery........................................................................................................19

SQL Startup Option............................................................................................................20

Trace Flag 8048...........................................................................................................20

Optimizations Pages...............................................................................................................20

SQL Server........................................................................................................................22

Maximum Degree of Parallelism......................................................................................22

Lightweight Pooling........................................................................................................22

Priority Boost................................................................................................................22

Min Server Memory (in MB)...........................................................................................22

Maximum Server Memory (in MB)...................................................................................23

Check Point..................................................................................................................23

Database..........................................................................................................................23

File Growth..................................................................................................................23

Database File on System Drive........................................................................................24

Multiple Database File on a Drive....................................................................................24

High Availability and Disaster Recovery................................................................................24

Mirrored Database........................................................................................................24

Availability Group.........................................................................................................25

Clustered SQL Server Instance.........................................................................................26

CPU.................................................................................................................................26

SQL Server Affinity........................................................................................................27

IO Affinity....................................................................................................................27

Storage............................................................................................................................28

Database RAID Level.....................................................................................................28

Drive Free Space...........................................................................................................28

Volume Mount Point.......................................................................................................28

Network...........................................................................................................................28

Contents 3