As our server started showing less than 300 sec as page life expectancy performance counter, we increased the physical memory from 2GB to 4GB and allocated 2560 MB to sql server 2005. Min and max both increased to 2560MB.
I expected to see the performance counter to show "total sql server memory" as 2560 MB, but it is still showing 1621376 KB.
The page life expectancy never go beyond 200 secs, expected to be atleast 300.
The server was restarted after installing the RAM
How can I make sure that the SQL server is using the allocated 2.5 GB RAM ? and How to increase the life page expectancy counter ?
Any help is appreciated.