Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
AbouttheStorageUnitentity
AbouttheStorageUnitentity
About the Storage Unit entity

...

The Overview displays general details of the Clariion unit such as its ID, and the number of SQL Server instances connected to it, as follows:

  • Requests    Displays Requests. Displays the number of I/O requests for the selected Clariion unit, over the selected time period, as collected by the Storage agent.

 

...

  • Load. Displays the I/O load for the selected Clariion unit, over the selected time period.

 

 

About viewing the performance of a Clariion unit

The Performance view displays the I/O requests (broken down into read/write operations) for the selected Clariion units, over the selected time period, as collected by the Storage agent. 

About viewing the load data of a Clariion unit

The Load view displays the I/O load (broken down into read/write operations) for the selected Clariion unit, over the selected time period.

 

About viewing throughput data of a Clariion unit

The Throughput view displays the I/O rate vs. throughput (in MB) of the selected unit, over the selected time period, as collected by the Storage agent.

 

About the Clariion Unit entity Association area

You can view general details and statistics counters on the entities associated to the selected Clariion Unit entity in the Association area. It is possible to associate to the Clariion Unit entity from a Clariion Storage Device entity. The following tabs are displayed:

 

...

  • Overview. Displays general details for the selected device.

 

...

  • Statistics. Displays I/O statistics for the selected device as collected by the Storage agent.

 

 

Anchor
AbouttheClariionDeviceentity
AbouttheClariionDeviceentity
About the Clariion Device entity

The Clariion Device entity displays general details and the I/O activity of the selected device. The following views are available:■    Overview

  • Overview

...

  • Performance

■    Performance

 

■    Load

 

■    Throughput

 

 

  • Load
  • Throughput

About getting an overview of a Clariion device

The Overview displays general details of the Clariion device such as unit ID, and number of DB files on the device, as follows: 

  • I/O

...

  • Wait. Displays the I/O wait for the selected device, over the selected time period, as collected by the Storage agent.

 

...

  • Requests. Displays the number of I/O requests for the selected device, over the selected time period, as collected by the Storage agent.

 

...

  • Load. Displays the I/O load (broken down into read/write operations) for the selected Clariion device, over the selected time period.

 

 

About viewing the performance of a Clariion device

The Performance view displays the I/O requests (broken down into read/write operations), for the selected Clariion device, over the selected time period, as collected by the Storage agent.

 

About viewing load data of a Clariion device

The Load view displays the I/O load of the selected Clariion device (broken down into read/write operations), over the selected time period. 

About viewing throughput data of a Clariion device

The Throughput view displays the I/O rate vs. throughput (in MB) of the selected device, over the selected time period, as collected by the Storage agent.

 

About the Clariion Device entity Association area

You can view general details and statistics counters on the entities associated to the selected Clariion Device entity in the Association area. It is possible to associate to the Clariion Device entity from the Database, Table, Index, Logical File, File Group and Clariion Storage Unit entities.

 

About the Devices on the same RAID Group entity (only for Clariion)

This entity is only available, in the Objects tab, if you have installed Precise for Database & Storage. For more information on the supported platforms, see the Precise Installation Guide.

When viewing a Thick Clariion Device (in the configuration tab), there is an option called "Devices on the same Raid Group" in the dropdown menu, that shows all of the devices who share the same Raid group as the selected device. 

Info

 

...

The graphs in the upper part of the screen (Overview, Performance, Load, and Throughput) - are the same graphs of that particular selected device - with no connection to the "Devices on the same Raid Group" option.

Anchor

...

AboutthePoolsentity

...

AboutthePoolsentity
About the Pools entity

The Pools entity, in the Objects tab, is only available if you have installed Precise for Database & Storage. For more information on the supported platforms, see the Precise Installation Guide.

***ask Lior for description here*** The following views are available:■    Overview

  • Overview

...

  • Performance

■    Performance

 

■    Load

 

■    Throughput

 

...

  • Load
  • Throughput

About the overview of a pool

The Overview, in the Objects tab, displays general details of the pool. 

 

About the performance of a pool

The Performance view, in the Objects tab, displays two overtime graphs that illustrate the following information:

 

...

  • The number of deferred writes, read requests, and write requests during the selected time period.

 

...

  • The read, write, and overall cache hit ratios over the selected time period.

 

 

About the load of a pool

The Load view, in the Objects tab, displays an overtime graph that illustrates the megabytes of data read and written during the selected time period.

 

About the throughput of a pool

The Throughput view, in the Objects tab, displays an overtime graph that illustrates the I/O rate (requests per second) and throughput (megabytes per second) during the selected time period.

 

 

Associating a pool with other entities

You can associate a pool in the Main area of the Objects tab with all the devices that are on the same disk as the hyper itself. You can display additional entities by using the More... option. 

 

Anchor
HowtheObjectstabcanhelpyouidentifyperformanceproblems
HowtheObjectstabcanhelpyouidentifyperformanceproblems
How the Objects tab can help you identify performance problems

...

The following section describes a few examples on how you can use the Objects tab to identify performance problems.

 

...

...

Anchor
ExaminingIOloadandperformanceofthevariousStorageentities

...

ExaminingIOloadandperformanceofthevariousStorageentities
Examining I/O load and performance of the various Storage entities

In theory, database files should be spread over different physical disks so that the I/O for one database file will not interfere with the I/O of a different database file. Therefore, tuning the I/O on a large storage machine is a complex task. Moving a database file from one disk to another can speed up some parts of the application but may slow down others.

...

To examine I/O load and performance of the various Storage entities

 

...

  1. In the Time Frame list, choose the period of time you want to analyze.

 

...

  1. In the Instance list, choose the item you want to analyze.

 

...

  1. On the Association controls in the Association area, click Databases. Drill down to the database you want to analyze.

 

...

  1. On the Association controls in the Association area, click Logical Files. Drill down to a specific logical file.

 

...

  1. On the View controls in the Main area, click Overview and observe the I/O statistics for the selected database file.

...

 

Precise. Performance intelligence from click to storage. Learn more > >

...