sql server and RAM
I'm using sql server 2008 enterprise on my online server, the main database has tables that expect more than 2 million records per month, as these tables grow sql server takes a lot from the 4GB memory installed and then closing the server ram.
  I've restricted the sql ram to 2GB but, when it uses these ram it stop working well destroy connections and performs too slowly.
 is it normal? and what can i do to get back the ram from sql server after querying these large tables?
sql server and RAM
===

I'm using sql server 2008 enterprise on my online server, the main database has tables that expect more than 2 million records per month, as these tables grow sql server takes a lot from the 4GB memory installed and then closing the server ram.
  I've restricted the sql ram to 2GB but, when it uses these ram it stop working well destroy connections and performs too slowly.
 is it normal? and what can i do to get back the ram from sql server after querying these large tables?