In our farm, we have 3 servers dedicated for SQL Server and all three are consuming 99% of the memory available. Looking in to it I learned that we didn't change the Max Memory setting in our SQL Server and therefore its consuming everything available.
This is giving us issues because its conflicting with our backup tool.
Our farm has a size of 2.5TB divided in the three servers(1TB, 1,3TB, 0.2TB). How can I measure the impact of setting a max memory now, changing the amount available for SQL from 64GB to 58GB?
Is there a Microsoft Guideline/Best Practice on this?