is ts SQL or Hardware problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

is ts SQL or Hardware problem

Author

Topic

beachtime1999
Starting Member

25 Posts

Posted - 2007-09-27 : 12:15:45

Hello
i am getting several of these errors in the SQL error logs:

SQL Server has encountered 6 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\Microsoft SQL Server\MSSQL\data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x000004FC. The offset of the latest long IO is: 0x000000438b2000

SQL Server has encountered 1 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [d:\Microsoft SQL Server\MSSQL\data\msdbdata.mdf] in database [msdb] (4). The OS file handle is 0x00000460. The offset of the latest long IO is: 0x00000004ed2000

but do not see any errors in the windows event viewer...so i am not sure if its a bad hardware, bad SQL or timeout adjustments

any help?

Steve

Kristen
Test

22859 Posts

Posted - 2007-09-27 : 13:03:47

Duplicate of http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90120

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources