Strategies for organising SQL Server with large amount of RAM
8
votes
1
answer
489
views
We now have a new server for our DB and amongst other things we have 128GB of RAM available (previously I had 16GB) . I know SQL Server is very good at managing it's resources, but I was wondering if there are any **special** settings or strategies that I should employ in either the server/db settings or processing code (stored procs/indexes etc) to ensure that SS takes **best** advantage of the available ram.
The DB is about 70GB and it's a non transactional db (it's a data warehouse). So basically large WRITE followed by massive READ is the normal flow of things.
Asked by Preet Sangha
(907 rep)
Mar 12, 2013, 10:47 PM
Last activity: Oct 29, 2022, 08:01 AM
Last activity: Oct 29, 2022, 08:01 AM