SQL Server Performance Forum – Threads Archive

17803, severity. 20, state 20 reason and remedy ?

I m seeing the below error in sql errorlog
"2005-10-28 14:33:19:.45 17803, severity. 20, state 20 " any idea guys what could be the resaon for this alert and what is the remedy for this?
I found in MS KB this is memory related issue can be resolved with SP4 but i’m running the sp4 alerady…
Thanks in advance..

Check whether any of these KBAs for any clues and process that fall under specified categories below:
http://support.microsoft.com/kb/319477
http://support.microsoft.com/kb/891719 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Both these KB no’s tells that the latest SP sorts out the problem.. But as i said earlier I see the sp4 running in my boxes. Any more pointers guys.

Confirm whether any scheduled jobs or processess running during this error.
PROFILER is your best bet to monitor the events on SQL Server. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

dont see convincing reason for any job / process during tht time and its impact on any error 17803 is there any other inputs from any body else?

Is there any other text associated with this error message?
Try reapplying SP4 again or check any recent changes in the infrastructure. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

some more text associated with this "Low free memory"

The source of information is limited and incomplete, try capturing stats using PERFMON and KBAhttp://support.microsoft.com/default.aspx?scid=kb;en-us;321363 for your information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>