| Author |
Topic |
|
beachtime1999
Starting Member
25 Posts |
 Posted - 2007-09-27 : 12:15:45
|
| Helloi 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: 0x000000438b2000SQL 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: 0x00000004ed2000but do not see any errors in the windows event viewer...so i am not sure if its a bad hardware, bad SQL or timeout adjustmentsany help?Steve |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-09-27 : 12:19:32
|
| Please dont post multiple threads:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90118http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90119Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-09-27 : 13:21:26
|
| I only submitted one not my fault |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-27 : 14:52:49
|
maybe clicked the button 3 times?  _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-09-27 : 16:17:45
|
| Maybee the website was broken. |
|
|
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-09-27 : 16:17:45
|
| Maybee the website was broken. |
|
|
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-09-27 : 16:18:33
|
| or my mouse Just single clicked last post as well |
|
|
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-09-27 : 16:18:33
|
| or my mouse Just single clicked last post as well |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-27 : 16:22:12
|
| hmm.. interesting.. so how come this doesn't happen to anyone else? _______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-27 : 16:22:57
|
| ok on with your question...can you show us the query you're using?_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 00:50:51
|
| The message is informational, added by sp4. Looks like you used tempdb a lot. |
|
|
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-09-28 : 16:44:13
|
| Thanks I am going to move the machine to VMware this weekend and see if its hard ware related |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 22:36:36
|
| Did you separate tempdb from other db files? |
|
|
|
beachtime1999
Starting Member
25 Posts |
Posted - 2007-10-03 : 14:49:05
|
| Must have been a hardware problem because the error is no longer showing in the logs since VMWARE move of machine |
|
|
|
crosan
Starting Member
13 Posts |
Posted - 2007-10-08 : 15:15:01
|
| From my experience bad/slow disks are usually the culprit. Are you doing any operations during that period that hit tempdb pretty heavily? If so, do you have tempdb on it's own harddrive/array? You might take a look at your disk performance metrics in perfmon around the times you experience these problems and see if you see anything out of the ordinary. If you've done any performance benchmarks (using a tool like SQLIOStress, which is free from microsoft)on this disk during normal operations, this should show you how much you are off by. |
|
|
|
|
is ts SQL or Hardware problem