Page History
...
The following Storage findings can help you tune your system:
- Storage Contention on Device (Clariion)
- Storage Contention on Device (Symmetrix Thick)
- Storage Contention on Device (Symmetrix Thin)
- Storage Contention on Device (Symmetrix F.A.S.T. VP)
- Storage Contention between Log and Datafiles
- Unbalanced Storage Devices Activity
- Storage with Low Cache Hit Ratio
- Storage Contention on tempdb
Anchor | ||||
---|---|---|---|---|
|
The instance spent X% x% of its resources waiting for I/O on the specified storage device.
...
Table 13-35 Storage Contention on Device findings
Column Description
What to do next ■ Examine the device activity over time and database files contention.
...
■ Consider storage tiering - a faster device may reduce the I/O wait time significantly.
Anchor | ||||
---|---|---|---|---|
|
The instance spent X% x% of its resources waiting for I/O on the specified storage device.
...
Table 13-36 Storage Contention on Device findings
Column Description
What to do next ■ Examine the device activity over time and database files contention.
...
■ Consider storage tiering - a faster device may reduce the I/O wait time significantly.
Anchor | ||||
---|---|---|---|---|
|
The instance spent x% of its resources waiting for I/O on the specified storage device.
...
Table 13-37 Storage Contention on Device findings
Column Description
What to do next ■ Examine the device activity over time and database files contention.
...
■ Consider storage tiering - a faster device may reduce the I/O wait time significantly.
Anchor | ||||
---|---|---|---|---|
|
The instance spent X% x% of its resources waiting for I/O on the specified storage device.
...
Table 13-38 Storage Contention on Device findings
Column Description
What to do next ■ Examine the device activity over time and database files contention.
...
■ Consider storage tiering - a faster device may reduce the I/O wait time significantly.
Anchor | ||||
---|---|---|---|---|
|
The instance spent X% x% of its resources waiting for I/O on the specified storage device. The device contains both Log files and Datafiles.
...
Table 13-39 Storage Contention between Log and Datafiles findings
Column Description
What to do next ■ Examine the device activity over time and database files contention.
...
Advice It has been detected that the Transaction Log files share the storage devices (LUNs) with other database files. Consult the storage administrator about provisioning the storage devices (LUNs) better to avoid this.
Anchor | ||||
---|---|---|---|---|
|
The instance I/O activity is not balanced across storage devices.
...
Table 13-40 Unbalanced Storage Device Activity findings
Column Description
What to do next ■ Compare the storage devices activity over time.
...
I/O load across the storage devices.
Anchor | ||||
---|---|---|---|---|
|
Storage with Low Cache Hit Ratio
The instance was waiting for I/O on storage devices with low cache read hit ratio.
...
■ Enabling "EMC Cache Partitioning", to isolate the instance cache and avoid external contentions.
Anchor | ||||
---|---|---|---|---|
|
Tempdb datafiles are frequently accessed by the instance. The majority of the operations performed are writing commands, which cause a heavy load on the underlying disks.
...
Table 13-42 Storage Contention on tempdb findings
Column Description
What to do next ■ Examine the device activity over time and database files contention.
...