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 - 2009-01-19 : 04:50:19
|
| Hi,We're running 2005 Express Edition on a server with 512MB RAM. When I look at processes in task manager the sqlsvr process is using about 384MB RAM. Based on that would there be any performance advantage to increasing to 1GB RAM? There are no other services running on that server.Thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 15:02:09
|
| Yes.It definitely will. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Doron
Starting Member
6 Posts |
Posted - 2009-02-12 : 06:25:09
|
| Yes, it will.The rest of the memory is used by the operating system.Even for small databases the SQL Server uses any available memory for caching.Nob Hill Software - tools for database people (+ free stuff!) Nob Hill Software - tools for database people (+ free stuff!)www.nobhillsoft.com |
|
|
|
|
|
|
Performance question