message in error log

[maswien]

We have a lot of message like following:


SQL Server has encountered 294 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [F:\MSSQL\DATA\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x00000814. The offset of the latest long I/O is: 0x00000031400000

What this mean?

Thanks

 

[ptheriault]

take a look at this kb, it should be helpful.

http://support.microsoft.com/kb/897284

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[maswien]

also I found there are 8 CPUs on the server and the TEMPDB only have one file. Is that asking for competition on the data file? Do I need to add more data files for the TEMPDB?

If the TEMPDB should be sized 8G and we have 8 CPUs, do I need to have 8 datafiles for TEMPDB and each of them at 1G?

 

[ptheriault]

It would help with performance to have 8 datafiles for tempdb but you don't have to set them to 1 gb each.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[olahallengren]

I agree that creating multiple tempdb data files is a best practise.

Another thing that you should consider is Instant File Initialization.

http://msdn.microsoft.com/en-us/library/ms175935.aspx

Kimberly Trip has a blog post about this.

http://www.sqlskills.com/blogs/kimberly/CommentView,guid,eed960df-c78f-4209-90e2-b924b0bcdd91.aspx

Ola Hallengren

http://ola.hallengren.com