Link to home
Start Free TrialLog in
Avatar of 25112
25112

asked on

memory for superior performance for a SQL 2012 wrk-station on Win10,i7

for a dedicated sql workstation laptop, win10, SSD disk, i7 processor, sql 2012
how much GB of memory would you recommend from your experience for optiomal and faster performance (using SSIS modules also)
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

I now go with at least 16gb for my dev laptops. but even 16 might not be enough if you are handling very large DBs.
windows 10, SSD disk, i7, 32GB,Sql Server 2012.

In 32 GB Ram you can handle medium and large database.
Avatar of 25112
25112

ASKER

can you please define large database.. are you talking by GBs? how much GB would you refer?

also 16 or 32 GB? is there a science to determine it or just user experience? also if you wanted to prove this to a team, is there any MSDN article that you can use/refer?
ASKER CERTIFIED SOLUTION
Avatar of Éric Moreau
Éric Moreau
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial