Anyone (everyone?) getting "IO requests taking longer than 15 seconds" in SQL Server?

Anyone (everyone?) getting \"IO requests taking longer than 15 seconds\" in SQL Server?

SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [H:\tempdev3.mdf] in database [tempdb] (2).

Your SQL Server SP level must be SP4 for these errors to show up in Program Files\Microsoft SQL Server\MSSQL\LOG or Program Files\Microsoft SQL Server\MSSQL\ERRORLOG.1, .3, .4, etc.

I am particularly interested in seeing if these errors show up for others' tempdb.

Re: Anyone (everyone?) getting \"IO requests taking longer than 15 seconds\" in SQL Server?

Hello,
this mistake happens when a transaction take too long time to be recorded in any database, to improve perfomance it should separate in three different drive units: TEMPDB, log files and Data files FILES.

Re: Anyone (everyone?) getting \"IO requests taking longer than 15 seconds\" in SQL Server?

[ QUOTE ]
Hello,
this mistake happens when a transaction take too long time to be recorded in any database, to improve perfomance it should separate in three different drive units: TEMPDB, log files and Data files FILES.

[/ QUOTE ]


Thanks, but I am aware of what causes it and some possible fixes but I was wondering if anyone else was seeing this in their logs.

Re: Anyone (everyone?) getting \"IO requests taking longer than 15 seconds\" in SQL Server?

I don't use MS sql, I use Oracle 10g, however, I personally don't see I/O waits that long. I'll have to look back, but I think I'm still looking at times in the milliseconds. My experience might not apply to you, but I thought I'd chime.