HP ESO 2.0 User Guide, Edition 3

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

What Is New In Release 2.0......................................................................................................6

2 Installing HP ESO.......................................................................................7

Software Requirements..............................................................................................................7

Installing the Software...............................................................................................................7

Uninstalling the Software...........................................................................................................8

Upgrading the Software............................................................................................................8

Silent Installation......................................................................................................................9

3 Using HP ESO..........................................................................................10

Starting System Management Homepage..................................................................................10

Microsoft SQL Server Security Settings.......................................................................................12

Getting Started Pages.............................................................................................................13

Quick Start Guide..............................................................................................................13

Introduction Page...............................................................................................................13

Administrator Session (Admin Session).......................................................................................14

SQL Server Login....................................................................................................................15

Settings Pages........................................................................................................................16

Configuration....................................................................................................................16

Data Collection.............................................................................................................16

Software Discovery........................................................................................................18

SQL Startup Option............................................................................................................18

Trace Flag 8048...........................................................................................................19

Optimizations Pages...............................................................................................................19

SQL Server........................................................................................................................20

Maximum Degree of Parallelism......................................................................................21

Lightweight Pooling........................................................................................................21

Priority Boost................................................................................................................21

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

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

Check Point..................................................................................................................22

Database..........................................................................................................................22

File Growth..................................................................................................................22

Database File on System Drive........................................................................................22

Multiple Database File on a Drive....................................................................................23

High Availability and Disaster Recovery................................................................................23

Mirrored Database........................................................................................................23

Availability Group.........................................................................................................24

Clustered SQL Server Instance.........................................................................................25

CPU.................................................................................................................................25

SQL Server Affinity........................................................................................................26

IO Affinity....................................................................................................................26

Storage............................................................................................................................26

Database RAID Level.....................................................................................................27

Drive Free Space...........................................................................................................27

Volume Mount Point.......................................................................................................27

Network...........................................................................................................................27

Contents 3