Wednesday, June 27, 2012 9:00 PM
I am seeing 5000 of this type of error per second in a server. However, the TextData is similar to below. Can someone enlighten me if I need to get worried about this?
Scan count 2, logical reads 6, physical reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.
Wednesday, June 27, 2012 9:20 PMModerator
Thursday, June 28, 2012 6:07 AMModerator
When STATISTICS IO is ON, the amount of disk activity is displayed. I think it is OK.
SET STATISTICS IO (Transact-SQL): http://msdn.microsoft.com/en-us/library/ms184361(v=sql.105).aspx.
If you have any problem, please post the error messages in detail and feel free to let me know.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Sunday, July 08, 2012 4:16 PM