SIMS and SQL Express

[interele]

So MS SQL Express only uses 1G of memory ( plus the program and some bits and pieces )

so has anyone got any idea why ours is at 1,490,000 and slowly climbing ?

 

Ta

 

M

[steve]

Is 1,490,000 the size of the mdf file on the hard disk or the amount of RAM the SQL service is using?

[interele]

the size of the sql process in memory

 

M

[kmount]

1 GB RAM: The 1 GB RAM limit is the memory limit available for the buffer pool. The buffer pool is used to store data pages and other information. However, memory needed to keep track of connections, locks, etc. is not counted toward the buffer pool limit. It is therefore possible that the server will use more than 1 GB in total, but it will never use more than 1GB for the buffer pool. This limitation prevents the use of Address Windowing Extensions (AWE) with SQL Server Express.

Link

 

Maybe this helps explain?