Alert on long I/O operation
Hosting Company raised an alert that there is absolutely no trace of as an issue according to SQL Monitor:
ALERT NAME: Rackspace - SQL I/O Error
TIME: 6/22/2011 7:02:21 PM
Event Description: SQL Server has encountered 174 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [M:\xcp_trans.mdf] in database [xcp_trans] (5). The OS file handle is 0x0000000000000BBC. The offset of the latest long I/O is: 0x000023b6d20000
Please augment SQL Monitor to do the equivalent alerting.
Custom metrics on sys.dm_io_virtual_file_stats are the best way to get this today
That's an error directly from the SQL error log, you should be able to alert on it through SQL monitor but off the top of my head I'm not sure what severity this is.
As an accidental DBA, this, to me, seems quite important... Is it? If so, is there a reason why it doesn't appear in the Alert-set for SQL Monitor? Planned inclusion, perhaps?
Helpful insight within SQL Monitor would assist folks like me to act upon what seems a serious condition.
Comments, Red-Gate folks...? (I don't know enough about this kind of Alert to know one way or the other whether to take note or ignore - need guidance)