I´m right working with a EMC server, running a virtual 2008 r2 and sql 2008 rs standar with only one DDBB.
Database has more than 2xx tables but only 15 users right now. The server was built using 8 GB, sql up to 6250MB.
SQL Server SP1 is NOT installed. The installer company does not want to do this!!!.
When the server is started everything goes fine, some weeks after this, the memory.. the total server amount memory usage grows up to 6x% 7x%.
After a invoicing process, heavy, the sql server uses up its 6,250MB ... this is until here, OK, but the total used ran goes up to 97 or 98 or 99%.
The sql server fulll its reserver memory.
Who is using from 6,250MB up to 8GB? why? because there no other software installed....
Shall this server have more ram installed? how much more?