How could we decide over how much memory will be good enough for a sql server 2012 standard edition instance having only 1 DB of around 250GB and it's very busy database through out the day, having high number of INSERTs/UPDATEs/DELETEs compared to SELECTs. Also lots of work done in Temptables by almost more than 1000 stored procedures everyday.
Thanks!
