Solution : https://service.sap.com/sap/support/notes/987961 (SAP Service marketplace login required)
Summary :
SAP Note highlights the importance of evaluating I/O performance in SAP systems on SQL Server 2005 or later, emphasizing the need for enterprise storage solutions. It explains assessing hardware components, particularly the storage subsystem, for alignment with required workloads. Key pointers include monitoring I/O performance using DBACockpit, understanding I/O latency targets, and employing necessary adjustments based on read/write patterns. The note specifies that success hinges on maintaining optimal latency ranges and frequently measuring these metrics. Prioritization of I/O performance is crucial for maintaining SAP application efficiency, particularly with the growing data volumes and the associated performance demands.
Key words :
disk sec /write disk read bytes/sec disk write bytes/sec, rid=/library/uuid/4ab89e84-0d01-0010-cda2-82ddc3548c65, synchronous san/nas replication adding additional latency, sata/fata equipped san/nas devices, disk backup devices 1mb sized reads, windows performance monitor windows performance monitor, disk queue length counters listed, io stall ms/write request, io stall ms/read request, general rule fiber channel disks
Related Notes :
| 1152848 | FAQ: SQL Server Wait Events |
| 521750 | FAQ: SQL Server 2000 I/O performance |