| Author |
Topic |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2007-03-26 : 19:18:56
|
| Hi,Is there any difficulties I should be aware of? I'm not running DTS and I think my DB is relatively simple. I've googled and not found anything that sticks out as a problem.We are getting a new server because we want more RAM, and better upgrade options. The hosting company recommended 64bit SQL, so I am thinking of following their recommendations.I am upgrading from a 2 x p4 2.8ghz xeons to 1 x Intel 5130 dual core 64 bit chip. I also will be going from 2 gigs to 4 gigs of RAM.Any thoughts I would love to hear.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-26 : 19:39:45
|
| We've migrated from SQL Server 2000 32-bit to SQL Server 2005 64-bit on most of our production systems without any problems. 4GB of RAM seems very small. We haven't had such a small amount of memory in production for quite some time. How big is your database? Are there other databases on the instance where your database will live?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2007-03-26 : 23:55:10
|
Hi Tara,Currently we are running with 3gb on windows 2000, however we have never been able to get SQL server to use more than 1730mb of RAM. The new system will be sql2005 on win 2003.We are really looking forward to this upgrade so it can take full advantage of the 4GB :) Even tho its not large, I suspect SQL2005 will eat it all up pretty fast.Currently the DB is 10gb including all the indexes etc. There are a couple other databases on the server, however they are farily small, and I don't think they are taking many resources (maybe 5%)Thanks !  |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-27 : 11:48:45
|
| 4GB of memory isn't enough for a 10GB database.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2007-03-27 : 23:48:29
|
| Hey,I'm fairly positive the database would LOVE to have more memory. Correct me if I am wrong but windows 2000 only supports 2gb of ram unless you change some boot settings? Well I haven't done that so I think because there are only 2gb available to windows, and some other services are using memory... Only 1730 mb are available to sql server. Maybe this makes sense ?As far as 4GB not being enough, I'm not sure what will be enough ? Should I have approx 10gb? Regardless doubling it should help alot and I will have room for more, so I can gauge it after the upgrade. Thanks again!mike123 |
|
|
|
pootle_flump
1064 Posts |
Posted - 2007-03-28 : 08:41:53
|
| Update stats & rebuild indexes as soon as you have migrated the dbs. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2007-03-28 : 10:31:44
|
| Time for perfmon. Is your buffer cache hit ratio below 98%? Any disk queues consistently over 1? Is the memory Pages/Sec counter consistently over 20 or 30? (Note, watch all of these counters for at least a week to make sure you do not miss any midnight batch jobs, or anything. If the answer is no to all three questions, you may have a database server that is perfectly happy with 1730 MB of RAM. Perhaps only a small part of the 10 GB database is active at any particular time. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-28 : 12:45:07
|
| There are two more performance counters you need to look at it, besides the ones mcrowley stated, to determine if you need more memory. These are:MSSQL$InstanceName\Memory Manager\Target Server Memory(KB) and Total Server Memory(KB)If Target is higher than Total, then the instance most likely needs more memory. Target is what the instance wants to grab. Total is what it has.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
upgrading from sql2000 32 bit to sql2005 64 bit