SQL Server DBA Interview | How to Assign or configure memory in SQL Server instance

In this video you will be learning how to Answer SQL Server DBA Interview Question "You have installed SQL Server Instance on Window 2008 Server. Total Memory of Server is 64 GB but you need to assign only 12 GB to SQL Server Instance, how would you do that?".

To change to 12 GB , As we know that one GB=1024 MB , we have to multiply 12*1024=12288 MB.

So we will put 12288 in the box to setup to 12 GB.

Complete list of SQL Server DBA Interview Questions by Tech Brothers

[sadiqmajid]

u good man keep it up. on video 18 so far loving it

[atul]

one more question

if we reduce the RAM usage for example RAM is 64 GB so how much can I set to avoid performance issues.

consider RAM usage is almost 100% for having multiple SQL server sessions ?

[atul]

why would i write 12 as the option here is to enter memory in MBs.
won't SQL consider 12 MB instead of 12GB if write only 12 there ?