Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Sharepoint Environment, getting Event 823/824 on the SQL Server

Posted on 2013-06-25
1
Medium Priority
?
1,066 Views
Last Modified: 2013-07-09
SharePoint DB Environment issues
VM Environment
2 Servers
Web Front End
Windows 2008 R2
SharePoint 2010

Database Back End
Windows 2008 R2
MS SQL Server 2008 x64

Going over the SQL Server logs we have seen a high occurrence of Error 823 and 824.  They also show up in the Windows Application Event Viewer.

This is the general description we have been getting:
823) The operating system returned error incorrect checksum (expected: 0xb016ce52; actual: 0xb016ce52) to SQL Server during a read at offset 0x00000000fc6000 in file 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\tempdb.mdf'. Additional messages in the SQL Server error log and system event log may provide more detail. This is a severe system-level error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.

824) SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x686d8353; actual: 0x8ab05a4c). It occurred during a read of page (1:204495) in database ID 2 at offset 0x00000063d9e000 in file 'E:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\tempdb.mdf'.  Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.


We restarted the SQL Server service so that tempdb would be recreated.  We also ran DBCC CHECKDB on all the databases and found no issues.

We have also used SQLIOSim to stress test the database server.  The stress test gives an error of:
Error: 0x80070467
Error Text: While accessing the hard disk, a disk operation failed even after retries.
Description: Buffer validation failed on C:\sqliosim.mdx Page: 398593, offset 0x8

We also get the following warnings
Error: 0x00000000
Error Text:
Description: 296 IO requests are outstanding for more than 15 sec.

Our system administrator performed a diagnostic on both the hard drive and memory for the environments.  No issues were found.

Our question is why would this happen to only temp.mdf?  And what are the chances that other databases could start getting checksum errors?  Any suggestions on what we could test next?
0
Comment
Question by:rmuyargas
1 Comment
 
LVL 20

Accepted Solution

by:
Marten Rune earned 1500 total points
ID: 39277102
Your harddisk subsystem, or your SAN disks are not healthy. This error is an indication of failing disks. If you use tempDB on it's own drive. Then you are lucky since this is the error you disclosed to us. Either way.

1. Replace the drives as fast as posssible.
2. Run consistency checks on all your user databases.
3. Make sure your backups are solid.

A disk that finda a faulty block, marks is as suspect, and stops using it. Therefore the databases with the most I/O is the most lightly to report these errors. I have never heard of a red herring error regarding Error 823 and 824

More info on:
http://support.microsoft.com/kb/2015756
https://www.simple-talk.com/sql/performance/reliable-storage-systems-for-sql-server/

You could look at SQLStress remotely. But it needs to be run as a local admin for the first time. I wouldn't run it locally.

Best regards, and good luck, Marten
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question