We have our SQL Server running on Windows 2008 Server R2 Edition with 48 GB of RAM.
Around 20 - 25 users use our Front End Application which communicates the SQL Database.
Apparently our SQL Server is taking too much of memory and keep growing to a level of 40GB of RAM ..!!! This forces us to restart the computer on weekly basis.
How should i set the limit of buffer usage and avoid excessive memory usage ?