Re: PAE problem question (KB834628)

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Yuan Shao (v-yshao_at_online.microsoft.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 03:05:10 GMT

Hi Frankm,

I agreed with Geoff N that it seems this problem is not mostly related the
problem in KB834628. Based on my experience, 823 errors are mostly hardware
related. Specially this error 823 on bad page ID is raised when the page ID
is invalid. When the error occurred, you can try to perform the following
steps to troubleshoot.

1. Check for error in the system and application from NT even viewer
2. Run DBCC checkdb on databse
a. IF it's sql 7.0, use "-y823" to start sql server and capture the dump
when the error is raised again
b. IF it's sql 2k, user DBCC Dumptrigger('SET', 823) to enable the dump
(this will NOT require the sql to be recycled!)
When the error 823 happens, it will catch the dump on it in sql errorlog,
3. Please also contact hardware vendor to run hardware diagnostic.

If the problem is very complex and you are unable to narrow down, you can
contact our PSS with the above information to continue working with a
dedicated Support Professional.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

Relevant Pages

  • Re: MSCS Questions
    ... hardware won't necessarily speed things up. ... > server solution than we had, including more memory and faster processors. ... > I understand that clustering isn't a performance benefit, ... >> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.server)
  • Re: High Availability
    ... SQL does not load balance. ... Hardware should be on Clustering HCL - ... the OS/SQL Software will die before the hardware will... ...
    (microsoft.public.windows.server.clustering)
  • Re: Web Server Setup
    ... Also, have a bunch of space for temporary SQL dbs, just for playing and tests. ... the specifications you described might be just the hardware for the test machine. ... I need to set up a server to handle an application that will pretty much ... 146GB Drives w/ RAID and dual hot swappable power supplys. ...
    (microsoft.public.windows.server.general)
  • Re: Performance problem...
    ... made many changings to the hardware structure. ... I have created many SPs instead using dynamic SQL ... The database is 1 GB large. ... >> at the same time, data from Profiler, Perfmon and SQL Analyser. ...
    (microsoft.public.sqlserver.tools)
  • Re: cidump documentation?
    ... Here is how I dump the catalog I created in C:\Program Files\Microsoft SQL ... Select what to dump: ... Select the keys to dump: ...
    (microsoft.public.sqlserver.fulltext)