OpsMgr 2012: AlertStage table backlog and I/O Waits
Thank you to Stephen Leuthold of BlogMyNog.com and HASMUG.com for sharing this excellent information! Situation: Massive I/O waits seen on the OperationsManagerDW resulting in major performance problems. It is unknown what the root cause of the Situation was. Reference: The Microsoft baseline I/O ranges for OLTP systems are as follows: 1-5ms for Log files 4-20ms for Data…