Post reply

Getting Error: 17803 Insufficient memory available

  • September 23, 2005 at 5:34 am

    #187819

    My server runs Windows 2000 Advanced Server sp4 and SQL Server 2000 sp3. The server has 4GB RAM.

    I am getting following error for my Production Server.

    1. Insufficient memory available

      >Error17803 , severity : 20,state:12 : this error is coming again and again  in the pig load time yeaterday and been noticed continuously many time why?
     
    2. Invalid buffer received from client.
     

    3. Memory is not releasing once it is occupied
     
    4. 1.5 gb memory sql server is ocuupying  as  it is  taking alot of memory. If we are making server down then it is releasing the cache and memory  but after as times go  is again taking alot of memory 1.5 gb or more  so it  means again Memory is not releasing once it is occupied.

    5. What is Audit Loggout? Why in profiler audit loggout is coming 3-4 times even database has thousans of users, so how it is maintained ?

    6. Audit logout in profiler showing  that it is taking 3 lakh milisec memory. which is not worth. why it is taking alot of memory.
     
    Please help me out.
     
    Thanks for ur help.

  • September 24, 2005 at 2:19 am

    #592829

    Hi Suneel,

    This will help u

    http://support.microsoft.com/kb/891719

     

    HTHP

    From

    Killer

    Learning manners.

  • September 27, 2005 at 3:32 am

    #593206

    Thanks Killer, what about audit logout. I had captured some traces where I found that Audit logout takes long long time... Its result I am getting long running transaction error from our BMC agent.

    Thanks in Advance.

  • September 27, 2005 at 10:03 pm

    #593526

    Hi Suneel,

     

    This will help u more

     

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/CL_SecDBSe.asp

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_1yr7.asp

    U can read more in  BOL just type Auditing

    Page heading "Auditing SQL Server Activity"

    I learnt about Auditing from this site

    http://www.databasejournal.com/features/mssql/article.php/3399241

    Hope this will help u

     

    from

    Killer

     

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply