Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mondeo
Constraint Violating Yak Guru
287 Posts |
 Posted - 2011-12-19 : 10:46:51
|
| Hi,I've got an SQL 2008 Enterprise server which contains a single DB which is ~6GB in size.The server has 8GB RAM.My question is would there be any benefit of increasing the server RAM from 8GB to 16GB.Would SQL benefit from the extra RAM even though the DB is only 6GB?Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-12-19 : 12:18:34
|
| Maybe, can't tell without examining the server's current performance, what the current bottlenecks are. Is that the only database on the server?Maybe have a quick read through http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/, especially chapter 4, which is memory--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
Performance question