• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 264
  • Last Modified:

will a 32 bit SQL starve on 4GB memory?

if a box has only 4 GB RAM, it really can't sustain any decent app, can it?

--Os and VAS take up 4 GB, and hence won't have any memory to spare for buffer pool. Is this understanding correct?

thanks
0
anushahanna
Asked:
anushahanna
  • 5
  • 2
  • 2
  • +1
5 Solutions
 
CboudrozCommented:
If you see that the OS and VAS taking the full 4 gb RAM, don't think that you can run SQL server on that server, but if you have 1 gig free maybe you can try it for a Development server, but never for a production server.



0
 
chapmandewCommented:
Depends on what is going on w/ the server...the 2gb for the VAS includes buffer pool memory as well.
0
 
anushahannaAuthor Commented:
>>If you see that the OS and VAS taking the full 4 gb RAM
what tool do you use for the above?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
anushahannaAuthor Commented:
>>the 2gb for the VAS includes buffer pool memory as well.

Which gets the priority first - VAS or buffer pool?

so technically, it can get starved if the box becomes busy, right? and can survive on light transaction load?
0
 
CboudrozCommented:
>>If you see that the OS and VAS taking the full 4 gb RAM
what tool do you use for the above?


You can have a quick Idea whit Windows Task Manager, or more info can be found whit the permon.exe
0
 
chapmandewCommented:
buffer pool is part of the VAS.

if it gets busy, it will page the pageable memory to the pagefile
0
 
anushahannaAuthor Commented:
>>if it gets busy, it will page the pageable memory to the pagefile

and if AWE is enabled, then it will go to the AWE part (when VAS gets busy), and then if need be then to the pagefile, right?
0
 
anushahannaAuthor Commented:
Thanks Cboudroz.
0
 
Scott PletcherSenior DBACommented:
VAS is **always** 4G for 32-bit Windows.

VAS has nothing directly to do with physical memory.

That's why it's call "Virtual" :-) .
0
 
anushahannaAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now