Post reply

No more buffers can be stolen.

  • October 15, 2006 at 8:35 pm

    #174708

     

    SQL 2000 Data Warehouse - incremental updates

    I'm getting this error message, Msg 802, Sev 17: No more buffers can be stolen. [SQLSTATE 42000], when trying to build a table (table does not build).

    This table has been build nightly for a little over a year.

    I've researched but cannot find any reference to why this error occurring.

    Any help would be greatly appreciated.

  • October 17, 2006 at 11:37 am

    #666304

    The first google hit on your message (No more buffers can be stolen) gives this link... follow it.

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

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • October 17, 2006 at 1:54 pm

    #666348

    Thanx so much.

     

  • June 2, 2009 at 12:17 am

    #1003190

    Hi All,

    i also got the same error "No more buffers can be stolen"..i checked the Microsoft links and i didn't get any help from that..i use only 3 databases..i thinnk it's a memory issue..i'm not able to figure it out?? where exactly we should check for this memory problem?? thanks..

  • June 2, 2009 at 5:15 am

    #1003302

    Hi,

    One thing is sure that there is some memory crunch which is causing this problem. Now we need to identify when this occurs and why? When say Why I mean to say in what circumstances we are reaching at a point where I am not able to allocate memory for my work.

    Normally when such errors occur they do log a message in SQL Server error logs like a Complete DBCC MEMORYSTATUS output or something else.

    Can you check your error logs and let me know if you have found any error during this time in the logs Apart from that please let me know below things as well.

    SQL Server Edition & Version (x86 or x64 bit)

    Max Server Memory Value

    Min Server Memory Value

    AWE Enabled or not

    Output of Boot.InI

    Regards

    GURSETHI

  • June 3, 2009 at 12:50 am

    #1003796

    Hi Gursethi,

    Thank you very much for your valuable time in answering my query. Actually, iam new to Sql server so i am unable to get answer for some of the questions. the answers which i got are :

    SQL Server Edition & Version (x86 or x64 bit) -- windows 2000 x86

    Max Server Memory Value -- dont know how to check

    Min Server Memory Value -- dont know how to check

    AWE Enabled or not -- dont know how to check

    Output of Boot.InI -- dont know how to check

    Thanks,

    Siva Prasad

Viewing 6 posts - 1 through 5 (of 5 total)

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