Page History
This section includes the following topics:
...
...
Anchor |
---|
...
|
...
|
Storage Unit entities can be monitored in the Objects tab, if you have installed Precise for Database & Storage.
If you want to see the Storage Unit entities that are monitored, select Storage Units in the Association area of the Objects tab. The information shown will give the DBA answers on whether there is a contention on a device due to re-tiering by performing the following actions:
Table 8-1 Actions
...
1 Actions
Action | Indicator | Possible Solution |
---|---|---|
Examine the device’s response time |
...
over time. | Marker on the Response Time graph. |
...
Consider moving heavy files to other devices to split the |
...
I/O load or moving the data to a faster storage device. |
Examine the device tier distribution and review other devices that share the same policy. |
...
Marker on Tier Distribution graph. |
...
Consider using a policy that secures more space on the high-end storage for the device. Verify if the policy is adequate for the type of activity. | |
Examine the device tier distribution and review other devices that share the same policy. |
...
Marker on the Association table. |
...
Consider moving other devices that use the fast (EFD) |
...
storage to another policy. |
...
Other information related to the Storage Unit entities that can be read from the Objects tab are:
...
- The type of storage the application is using (Thin/Thick).
...
- The type of policy that is associated to each device.
...
- The pools the application is using.
...
- How full the pools are.
...
- Who else is using the pools.
...
- How much of each storage Tier is being used by each device.
...
...
About the Association area
In the Association area, you can select the entities from the dropdown menu. When choosing Storage Units to see all of the Storage units (storage arrays) that are connected to the monitored server (either physically or via a remote gatekeeper), two tabs are shown at the right side of the table, Statistics - statistical :
- Statistics. Statistical data about the storage units
...
...
- Configuration
...
- . Data regarding the unit's configuration.
Each tab has its own columns in the table. The following tables describe the different column headings.
Table 8-2 Statistics
Column Name Description
...
2 Statistics
Column Name | Description |
---|---|
Type | Type of the device: Symmetrix or Clariion. |
Unit |
...
ID | The ID of the unit |
Used By |
...
Instance | Shows whether the Oracle database instance is using the storage unit (the database has files on at least one storage device that belongs to that unit). |
Read/Write |
...
Req. |
...
The number of read and write requests. |
...
Load | The amount of data that the unit handled within the timeframe. |
Throughput |
...
The amount of data per second (MB/Sec.).*** |
I/O |
...
Rate | The amount of requests to the unit per second. |
Seq. |
...
Reads | The amount of sequential requests. |
Cache Hit |
...
Ratio | The amount of requests that were answered by the cache in relation to the total amount |
...
(only for Symmetrix). |
Read Hit |
...
Ratio | The percentage of read hits in relation to the total cache hit ratio (only for Symmetrix). |
Write Hit |
...
Ratio | The percentage of write hits in relation to the total cache hit ratio (only for Symmetrix). |
.
Table 8-3 Configuration3 Configuration
Column Name Description
...
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 | ||||
---|---|---|---|---|
|
The following section describes a few examples on how you can use the Objects tab to identify performance problems.
...