HP ProLiant DL980 G7 Server - Manual (Page 3)

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