SQL Server Performance

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

Discussion in 'General DBA Questions' started by ranjandba, Oct 30, 2005.

  1. ranjandba New Member

    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..
  2. satya Moderator

  3. ranjandba New Member

    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.
  4. satya Moderator

    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.
  5. ranjandba New Member

    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?
  6. satya Moderator

    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.
  7. ranjandba New Member

    some more text associated with this "Low free memory"
  8. satya Moderator

Share This Page