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?)
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.