Link to home
Start Free TrialLog in
Avatar of smj001
smj001

asked on

16Gb Table, how much Ram and Optimization

We have a SQL 4 server running a single large database. The database has 7 tiny tables and one very large 16Gb table. The index file for this table is also 1Gb.

Currently queries often need to query this table and are very slow. Querying the table results in very heavy disk read traffic. The server currently only has 10Gb RAM, if I got a new server with 32Gb RAM (And space for 64Gb) I'm sure it could be made to work properly but do I need to worry about settings like key_buffer_size? (Would this need to be set to 2Gb?)
ASKER CERTIFIED SOLUTION
Avatar of michofreiha
michofreiha
Flag of Lebanon image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial