Hp ProLiant DL980 G7 Server Manuel d'utilisateur

HP Enterprise SQL Optimizer (HP ESO) 1.0User GuideHP Part Number: AM426-9013APublished: April 2012Edition: 2.1

3 Using HP ESOTo use HP ESO, you must first launch the HP System Management Homepage (SMH) software,which is also the starting point for many other HP

Figure 7 SMH Sign In PageYour user name and password must be a valid account in a group configured in the SMHusers groups. The Sign In button validate

5. The Enterprise SQL Optimizer Main page displays. Refer to the next section for instructionson using HP ESO.Getting Started PagesWhen first run, HP

Figure 10 Floating Help TextSettings PagesUse the Settings pages to configure some of your settings prior to discovery and optimization ofthe HP serve

Figure 12 Configuration PageUser input fields in the Data Collection Settings section include the following:• START ON ⇒ Lets you select the date and

Figure 13 Performance MonitorSoftware DiscoveryHP ESO's Software Discovery feature checks to see if the latest HP software, drivers, and firmware

• New Value ⇒ This field contains the new parameter value to be applied to the system. Bydefault, this field contains the recommended value. However,

Lightweight PoolingUse the Lightweight Pooling option to reduce system overhead associated with the excessive contextswitching sometimes seen in symme

Figure 15 Database PageFile GrowthThe File Growth option specifies the method of incremental allocation applied when an operatingsystem file is extend

HP ESO generally recommends that you confine SQL instances with relatively light workloads tounder-utilized CPUs. This results in some SQL instance af

© Copyright 2011–2012 Hewlett-Packard Development Company, L.P.Legal NoticesConfidential computer software. Valid license from HP required for possess

Figure 17 Storage PageDatabase RAID LevelThe recommended RAID level displays on this screen. Storage of TempDB or TempDB Log files isrecommended on RA

Figure 18 Network PageNUMA Node AffinityNUMA (Non Uniform Memory Access) Node is a logical grouping of processors that share common,directly-linked ph

Figure 19 System PagePower PlanThe settings in this section resemble the Windows Power Option settings. The default HP ESOsetting here is High Perform

Figure 20 Workload and Performance History PageTo view and/or export a performance report, follow these steps:1. Select the CSV file you want to view

Figure 21 Save/Rollback SQL Configuration PageThe Save/Rollback SQL Configuration page displays the following values or controls:• Save Current Settin

Figure 22 Online Help PageHelp Pages 25

4 Support and Other ResourcesContacting HPBefore You Contact HPBe sure to have the following information available before you call or contact HP:• Tec

New and Changed Information in This EditionEdition 1 is the initial release of this document, dated November 2011.This second edition provides additio

ContentsAbout This Document...5Publishing History...

4 Support and Other Resources...26Contacting HP ...

About This DocumentThis document describes how to install and use HP's Enterprise SQL Optimizer (HP ESO) software.HP ESO was created for system a

1 IntroductionHP Enterprise SQL Optimizer (HP ESO) is a software tool that greatly simplifies and consolidatesthe process of tuning HP ProLiant DL980

2 Installing HP ESOSoftware RequirementsThe following prerequisite software is required in order for HP ESO to function properly:• HP System Managemen

Figure 2 Package Setup Window4. The second installation window displays. Click Install to continue. The installation begins, witha progress bar indica

If the prerequisite HP Insight Management WBEM Provider software is not installed on the system,you will see the following warning message during HP E