Sample Header Ad - 728x90

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