We hare having issues with some small businesses running server 2008 with SQL. The SQL instances eat all available memory after a few days of heavy use.
In management studio, should we limit the instance or buy more ram? Currently we have 8 gig of ram. SQL is using 2-3 gigs per instance and the servers begin to crawl until we reboot them.
if limiting the instance is the route to take... any particular size anyone can recommend? most these are small business offices with maybe 10 users.