Showing posts with label checking. Show all posts
Showing posts with label checking. Show all posts

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