Search code examples
sql-serversql-server-2008-express

Limited memory usage of sql server 2008 express?

I want to install sql server 2008 express on my laptop that has 1 GB memory, but my database contains lots of binary data that I don't want spending all my RAM. I would much rather sacrifice sql performance (make it page) in favor of other applications.

Is it possible to limit the memory footprint of sql server?

Solution

  • look here and here

    essentially sp_configure 'max server memory' I think