Collecting data for analysis and optimization – HP ProLiant DL980 G7 Server User Manual
Page 31
Settings pages: Setting parameters for data collection
Use the Data Collection page to configure some of your data collection settings prior to discovery
and optimization of the HP server, the Windows Operating System (OS), and SQL Server.
Data Collection page: Collecting data for analysis and optimization recommendations
The data collection feature collects data from the Windows OS, SQL Server Database Engine, and
Analysis Services. Data includes CPU, memory, and IO utilization; and SQL Server transaction
rates. Collected data is saved in the form of CSV (Comma Separated Value) files located at
%ProgramFiles%\McPerfOpt\Data
, as shown in
Figure 26 CSV data files
These CSV files are used by HP ESO for analysis, and form the basis of its optimization
recommendations and its performance and workload history reports.
IMPORTANT:
To ensure suitability of HP ESO’s optimization recommendations, perform data
collection during typical business workloads.
Whenever major SQL Server configuration changes are made while the current ESO Admin Session
is active, rerun data collection. (Examples of major configuration changes include adding or
removing an SQL instance, database, or database file.) Data that was collected prior to a major
configuration change will likely be obsolete. Rerunning the data collection ensures that optimization
recommendations and reports are aligned to the current configuration and workload.
Click Data Collection in the HP ESO navigation pane to display the Data Collection page.
shows a Data Collection page. This page allows you to set data collection parameters
and to start the data collection process.
Settings pages: Setting parameters for data collection
31