SQL Server throws and 825 error when it could not read a page between one a three times, but only at level 10. Add a specific Agent alert for error 825 to get a jump on IO system problems.
From a post on SQLSkills.com by Paul S. Randal - http://www.sqlskills.com/BLOGS/PAUL/post/A-little-known-sign-of-impending-doom-error-825.aspx for more details
No comments:
Post a Comment