Also depends on the video driver for the card as well. Most NVidia drivers like to use up a lot of memory, the more you give the driver, the more it will take.
With the 12.41 drivers and a 64MB NVidia card (the card type really does not matter), if you set the AGP aperature to 128MB, the driver will consume 92MB of combined AGP/video memory, and that is immediately after DX is initialized, before anything is loaded from the application.
I really do not know what they are doing with all that ram.
Anyway, if you reset the AGP aperature down to 64MB, then the card takes 52MB of combined AGP/video memory.
ATI's Radeon family uses a lot too, but it caps at about 76MB, whether you have 128MB or 64MB AGP aperature and a 64MB video card.
Oh, all this was tested at 1024x768x32 bit. The amount of memory used goes up significantly as you increase your video resolution for either manufacturer.
I usually use the above resolution for all games, so I end up setting my AGP to 64MB, but if you play at higher resolutions, you may need to increase the amount of AGP memory.
Hope that helps.