calljk
asked on
SQL instance limiting memory
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.