In simple words, it is a window through which the AGP graphics device can borrow system RAM in case its own local RAM isn't enough to hold all the stuff required for the 3D scene to be rendered.
You want that to be large, but larger than half your system memory size obviously isn't useful. Note that the actual borrowing is dynamic, so making the window larger than needed doesn't do any harm.
regards, Peter