Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

message in error log

Status
Not open for further replies.

maswien

Technical User
Sep 24, 2003
1,286
CA

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
 
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?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top