Limit SQL 2008 R2 Express in memory usage? (1 Viewer)

[lightman]

is it an good idea to limit the maximum memory size of the SQL 2008 R2 Express database?

now it use 1GB+

in the wiki there is a metion for 128MB, but is that still reasonable for the current MePo 1.2.x versions?

 

[ROLA]

It's always a good idea to limit the SQL-server to maximum memory.
You can/should also lock SQL pages to memory, making swapping to disk impossible for the SQL-server.

How to: Enable the Lock Pages in Memory Option (Windows)

 

[lightman]

for the current software versions SQL 2008 R2 Express and MePo 1.2.x what is a correct threshold of maxiumum memory value?

512MB ?
1GB ?

 

[ROLA]

Depends on how much RAM you have to spare.

How big is your database?
Since there is limited access/users on the server, there should be pointless of reserving resources to the SQL-server.
256MB should be enought to cache your database.

 

[tourettes]

If MS SQL process is using 1GB then let it be using It's the cache that uses the available free RAM. When ever OS or other processes are needing free RAM MS SQL is releasing some cached content and wont cause any swapping to happen.

 

[lightman]

my database is 65MB in size

 

[tourettes]

my database is 65MB in size

And it is possible to create quite many combinations (worth more than few GBs) from such amount of data.