HP ProLiant DL980 G7 Server - Manual (Page 3)

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