We are using Windows server 2012 standard server with 2.4 GHz and 16 GB RAM. SQL Server 2012 is installed in it and also our primary application is installed on the server.
Using transaction replication to get the latest data b/w the servers.
The server performance hits badly sometimes when SQL Server holding the entire memory of the server.
Will the performance of the server improve when increasing the RAM to 32 GB?