March 15, 2012 at 10:13 am
Hi guys..
Any idea about this message ?
SQL Server has encountered 4375 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file
SQL Server has encountered 1726 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file
SQL Server has encountered 3661 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file.
Thanks .
March 15, 2012 at 10:41 am
Just one possibility is a lack of worker threads. Don't really have enough information to really provide you more than guesses unfortunately.
March 15, 2012 at 10:56 am
Still had this one between my favourites...
Hope it's ok to just post a link.
March 15, 2012 at 11:10 am
Slow IO subsystem generally. A slow IO is when SQL sends an IO request to the operating system and 15 seconds later the IO has not completed. The messages are output every minute.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2012 at 11:11 am
rooierus (3/15/2012)
Still had this one between my favourites...Hope it's ok to just post a link.
March 15, 2012 at 11:50 am
showing me number of pending I/Os - 20..
how can reduce?
any idea?
March 15, 2012 at 11:52 am
Optimise the queries or upgrade the IO subsystem. I recommend the former.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 15, 2012 at 12:07 pm
can you give me more detail about optimize query or upgrade IO subsystem please?
thanks
March 15, 2012 at 2:48 pm
Optimise queries - find the heavy IO queries and tune them, or get someone in to tune them for you. See Grant's Query Performance Tuning Distilled book for more details
Upgrade IO subsystem - faster drives, more drives, multiple HBAs (assuming SAN), etc. Not cheap.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply