HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Performance

 
SOLVED
Go to solution
bublik
Valued Contributor

SQL Performance

I have these messages in event viewer on SQL 2005 SP3

"SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file"

Usually during this type we have some queries ruinning on the SQL server....

 

Has anyone seen these messages before?

2 REPLIES
bryan_hadzik
Frequent Advisor

Re: SQL Performance

Does the SQL server have its own volume for data files, and another one for logs? Are you using the mpio plugin?

bublik
Valued Contributor
Solution

Re: SQL Performance

found the bottleneck on the network. Throughput of 120 MB per second on 1 GB network.