Buffers - how they work

So I've done some research into this LazyWriter No Free buffers found
issue. My question is, when all the buffers are taken up (i see that my
free buffers hovers around 26-50 (fifty, not fifty thousand) out of
150k). So what happens when there are 0 free buffers. The lazy writer
just freaks out and locks? Doesn't the buffer manager go to virtual
memory to get new buffers?
Would this happen?
A long running transaction keep all the buffers held and dirty then some
simple process tries to grab some buffers. This simple process can't
get access to any buffers and SQL just locks with the lazy writer error.DBCC MEMORYSTATUS
Hassan wrote:
> How do you find out the free buffers ?
> "Shaun Farrugia" <far!!!!ugia!!!s@.dte!!!!ener!gy.com> wrote in message
> news:OdDql3RgDHA.1764@.TK2MSFTNGP09.phx.gbl...
>>So I've done some research into this LazyWriter No Free buffers found
>>issue. My question is, when all the buffers are taken up (i see that my
>>free buffers hovers around 26-50 (fifty, not fifty thousand) out of
>>150k). So what happens when there are 0 free buffers. The lazy writer
>>just freaks out and locks? Doesn't the buffer manager go to virtual
>>memory to get new buffers?
>>Would this happen?
>>A long running transaction keep all the buffers held and dirty then some
>>simple process tries to grab some buffers. This simple process can't
>>get access to any buffers and SQL just locks with the lazy writer error.
>
>