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 |
|
wavegeek
Starting Member
2 Posts |
 Posted - 2007-12-10 : 19:25:39
|
| My organization is currently migrating about 35 databases from SQL 2000 to SQL 2005. Most of the databases are small with the largest being about 6gb. These databases are not very transaction intensive. We are about half way through as we started the project a year ago. We purchased new hardware for this SQL 2005 so it is a side-by-side migration and it has been going well so far. I made one oversight which I think will come back to haunt us down the line. I installed Windows Server 2003 Standard R2 Edition and of course now I am considering putting more RAM in the server. We have 4 GB of RAM in the server and of course Standard Edition will not address more 4GB of physical ram. I have not seen any memory pressure yet but as databases are migrated over the amount of physical RAM drops. My buffer hit cahce ratio and page life expectancy performance counters are fine so far. The server is a brand new HP DL 380 G5 with with tons of disk and processing power, but only 4GB of RAM. I can't migrate to another server with more ram obviously.1. What would you do in a situation like this?2. I could do an in-place upgrade to Windows Server 2003 Enterprise R2. Has anyone attempted an in-place upgrade? I have no applicationson this server, just SQL 2005 Standard.3. Would the /3gb switch be an option? I have heard mixed reviews on this one.As far as database optimization, %75 of the databases are third party so we have little flexibility in tuning them or redesigningtables.Thanks,Alex |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-10 : 21:55:55
|
| 1. Add more memory if needed.2. I did and no issue so far.3. It helps if server has less than 16gb memory. |
 |
|
|
wavegeek
Starting Member
2 Posts |
Posted - 2007-12-11 : 11:41:48
|
| I am trying to find out if the /3gb switch would work ok or if an in-place upgrade to Windows Server 2003 Enterprise Edition would be the best option and if people have attempted the in-place upgrade before. |
|
|
|
|
|
|
Need more available memory for SQL 2005...options?