Error log Message - 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 2005 Forums

SQL Server Administration (2005)

Error log Message

Author

Topic

buzzi
Starting Member

48 Posts

Posted - 2008-10-09 : 18:00:15

Hi all,
I am seeing this error in the error log during today
(SQL Server has encountered 418 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [S:\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x000000000000083C. The offset of the latest long I/O is: 0x00000d641a0000
)
followed by

Source spid51
Message
BobMgr::GetBuf: Sort Big Output Buffer write not complete after 60 seconds.

starting at 10/9/2008 1:48:34 AM to 10/9/2008 2:48:34 AM, i got this record arround 12 times.After that i am not seeing this error, sofar.

Any idea of whats going on.The user activity will be minumal during this time.Not sure what this error means

Thanks for anybodys help

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-10 : 00:50:23

I have seen this error before. This happens when there is high I/O pressure on drive where TEMPDB resides. Does Your Tempdb reside in different Drive?

buzzi
Starting Member

48 Posts

Posted - 2008-10-10 : 14:27:14

Thanks for the response,
No all my datafiles are on the SAME SAN Drive.Any idea how to resolve this issue, Also I see my tempdb size unreasonable at (70GB). Is there a way to find out what are all the tables that are getting used by looking at the TempDB.I was thinking that there is lot of tuning that i need to do.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-10 : 14:31:21

The best thing to do here is to ensure that "lock pages in memory" is enabled (not sure what edition of SQL Server you are using though) and that you have multiple data files in place to match the number of CPUs that you have: http://weblogs.sqlteam.com/tarad/archive/2008/05/20/60604.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

buzzi
Starting Member

48 Posts

Posted - 2008-10-13 : 16:48:44

Thanks to Tara & Sodeep.

Tara,,
I couldn't get the info soon enough,But i was having 64bit SQL Server 2005 Standard Edition, I was reading in some other post that i will not be able to set the option that you mentioned""lock pages in memory" if i have a standard edition & can only be done in the enterprise edition.

Also regarding my 2nd question: are the any tricks to find out why my tempdb size is sohigh?

Thanks you both

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-10-13 : 17:11:02

Read this:

http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources