SAP Note 521750 - FAQ: SQL Server 2000 I/O performance

Component : Microsoft SQL Server - Backoffice Service Delivery

Solution : https://service.sap.com/sap/support/notes/521750 (SAP Service marketplace login required)

Key words :
st04 -> 'detail analysis menu' -> menu 'db analysis' -> 'io, st04 -> 'detail analysis menu' -> 'system tables' -> 'system functions', st04 -> detail analysis menu -> db utilities -> dbcc sqlperf, job       sap_<sid>_<db>_mssql_collectoris running, display job sap_<sid>_<db>_mssql_collector, declare @db smallint set @db=db_id, icon 'layout setting' choose 'change layout', st04 ->'detail analysis menu' -> 'sql processes', st04 -> 'detail analysis menu' -> 'io, disk write queue lengthin case

Related Notes :

1152848FAQ: SQL Server Wait Events
987961FAQ: SQL Server I/O performance
886337IO performance problems due to misaligned disk sectors