1 introduction, Benefits of using hp eso, Main features of hp eso – HP ProLiant DL980 G7 Server User Manual

Page 6: Benefits of using hp eso main features of hp eso

Advertising
background image

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,
Windows Server 2012, or Windows 2012 R2 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

Advertising