Monday, March 26, 2012

garbage in sql server log files

hi,
My database server had hung up recently, and I had to restart it.
After checking the log I found some garbage entries in it.
has anyone encountered similar errors?
harshal.Garbage entry means what some of kind of ASCII characters or SQL DMP information?

Post a sample one here.|||Originally posted by Satya
Garbage entry means what some of kind of ASCII characters or SQL DMP information?

Post a sample one here.

There is some kind of ascii code|||What is the level of service pack on SQL & OS?
What was the error related when it hung?
Any SQL.DMP files are created?|||Originally posted by Satya
What is the level of service pack on SQL & OS?
What was the error related when it hung?
Any SQL.DMP files are created?

Error: 17883, Severity: 1, State: 0
The Scheduler 0 appears to be hung. SPID 94, ECID 0, UMS Context 0x39836B08.

sp3a and win 2k .|||Review information on following KBAs to deal with:
http://support.microsoft.com/?kbid=816840

http://support.microsoft.com/default.aspx?scid=kb;en-us;810885 - I feel this may be applicable to the situation if you use high-end subsystems h/w.

HTHsql

No comments:

Post a Comment