We're running SQL Server Express for our project. I'm trying to prove that we have to move to Standard or Web version of it. Just because I suspect that because of Express edition limitation it can't use as much of RAM as it needs. When I look at SQL Server process in the process explorer I always see that it utilizes around 1.5 gigs of RAM and never goes higher.
Is there a tool which will allow me to tell that the maximum memory amount it can use is really the issue?
Update. We're using SQL Server 2008 R2 SP1 Express Edition with Advanced Services (64-bit). Results of DBCC are here. Maximum allowed amount of memory is 4 gigabytes.