Hp ProLiant DL980 G7 Server User Manual download pdf (Page 6)

1 Introduction

This chapter describes the main benefits and features of the HP Enterprise SQL Optimizer (HP ESO).

Benefits of using HP ESO

HP Enterprise SQL Optimizer (HP ESO) is a software tool that greatly simplifies and consolidates

the process of tuning HP ProLiant DL980 G7 servers running Microsoft Windows Server 2008 or

Windows Server 2012 x64 editions, and SQL Server 2008, SQL Server 2008 R2, or SQL Server

2012. Use HP ESO to:

• Reduce the time and complexity of configuring and tuning systems running SQL Server

• Reduce the number of support calls due to misconfigured systems

• Help users optimize their configuration to ensure top SQL Server performance

• Improve customer satisfaction

HP ESO achieves these goals by providing optimization tools for the following system components:

• Server – Includes hardware-related recommendations such as placement of PCI cards and

proper storage drive configurations, and information on the update status of HP software,

drivers, and firmware

• Operating System – Includes settings for Power Management Options and storage volumes

• Microsoft SQL Server – Includes settings such as priority boost, light-weight pooling, CPU

affinity, and more

You access these optimization tools by logging in to SQL instances. There are two types of SQL

instances:

• SQL Server Database Engine instances — Handle user requests for reading and writing data

in databases for any of three different types of applications:

◦ Online Transaction Processing (OLTP) Database Engine

◦ Data Warehouse (DW) Database Engine

◦ SAP Database Engine

In general, the term “Database Engine” refers to the OLTP Database Engine, unless one of the

other two types of Database Engine is specifically mentioned.

• Analysis Services instances — Analyze the transactions that occur in the database. It provides

online analytical processing (OLAP) and data mining capabilities.

Main features of HP ESO

HP ESO provides the following functionality for configuring and tuning your server and Microsoft

SQL Server:

• Scheduled or manual data collection, for use as reference when optimizing the system and

SQL Server

• Built in knowledge of the hardware architecture, to properly optimize the server

• Reports page that provides a graphical display of data collection parameters, for use in

analysis and interpretation, with the ability to export to a file

• Built-in WBEM-based instrumentation for quick integration with other management tools such

as HP System Insight Manager

• Capability to roll back to previously saved configurations. Use this feature to save the current

configuration, then retrieve and apply it in the future if necessary

6 Introduction

1 2 3 4 5 6 7 8 9 10 11 ... 80 81

No comments

Hp ProLiant DL980 G7 Server User Manual Page 6