January 15, 2009 at 12:06 am
hi
The database size is 2.5 GB, and i have 16 GB RAM available at my database server and i want to fully utilized my RAM and want to put my whole databse in memory, please let me know how can i do this.
January 15, 2009 at 12:51 am
SQL does a good job of caching frequently used data in memory, if there's sufficient memory available. If the tables in that database are used often, they will be in memory.
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
January 21, 2009 at 4:02 am
If your server is 32-bit, make sure you have AWE enabled. If you are not sure how to do this, look in Books Online (BOL).
If you are running 64-bit then nothing further needs to be done.
Remember, for both AWE and 64-bit you need to set SQL maximum memory to get the best performance out of SQL Server.
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply