November 23, 2014 at 9:09 am
Dear experts
How to use the bcdedit to edit proportional of virtual address space, to make sql take higher memory
and in which case do i need to use this tool?
how to use BCDEDIT \increaseuserva ????
Thanks lot
November 24, 2014 at 7:25 am
You don't, unless you're running 32-bit SQL Server on a 32-bit OS.
What's the background? What are you trying to do and why?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 1, 2014 at 4:14 am
See https://sqlserverfinebuild.codeplex.com/wikipage?title=Windows%20Memory%20Switches for suggestions of what switches you should use.
As Gail says, most of these settings only give a benefit in a small number of situations.
The UserVa value is only relevant on a 32-bit OS that already has the 3GB and PAE switches set and the server has between 12GB and 16Gb memory. You should not use bcdedit /set IncreaseUserVA nnn unless you are sure the default value is causing you a problem and you have already calculated what value of UserVA you can safely use.
If you explain the problem you think you have, rather than the solution you think you need, then people on this forum may be able to help you more.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply