April 6, 2007 at 8:51 am
We just migrated the sql 2000 servers to sql 2005.The migration went on fine and the servers were working fine for couple of weeks.
For past few days one of this 2005 server just kept going down and the sql error logs gives out a message saying that
"SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [F:\data\database1_Data.mdf] in database [database1] (15). The OS file handle is 0x000004F8. The offset of the latest long IO is: 0x00000464248000."
I suspect that this a hardware failure and has got nothing to do with the migration.
Could anyone just confirm this and provide us with a solution.Thanks
April 6, 2007 at 10:13 am
You get this error when there is something wrong in the io path. This can be many things hardware problems, driver issues, anti virus software etc.
There is no easy place to start you just have to be systematic about it and eliminate one thing at a time. Saying that however every occurence I have seen of this has been casued by anti virus software so I would start by making sure that all your mdf and ldf files are excluded from being scanned by the anti virus software.
This article may help you
http://msdn2.microsoft.com/en-us/library/aa175396(SQL.80).aspx
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/21/642314.aspx
David
April 6, 2007 at 8:26 pm
Is that the only messsage before SQL Server goes down ?
does the SQL service stop altogther or just the response gets slower ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply