egurally, I am checking my SQL Server log and found this error message like: IO requests taking longer than 15 seconds to complete.
SQL Server uses asynchronous IO, in which SQL Server releases the thread to allow further threads.
This operation hardly takes 15ms, but under certain condition delays will occur and this kind of error will log into SQL Server logs.
The possible reasons are:
- Excessive I/O requested by SQL Server
- I/O subsystem problems
- I/O subsystem misconfiguration
- Inefficient placement of data files on disk
Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.
If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.
I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.