March 24, 2010 at 4:13 am
Hi All,
I have read in Microsft site for SQL 2000 to 2008 upgrade requires more hardware resources.
What can anyone tell/justify what would be the major impact on hardware resources while upgrading from 2000 to 2008?
Suppose i have windows 2000 Server box on top of which sql 2000 with sp4 is running.Existing RAM is 3 GB.
Database Size is 40 GB.
Total Disk size Free space
C:\50 GB 20 GB
D:\200GB100 GB
Currently my data and log files are residing in D:\ drive itself.
Basically, i want to know what are all the various factors which contribute to more hardware resources if i go for 2008 upgradation.
Expecting for more suggestions.
Thanks in Advance.
March 26, 2010 at 3:57 pm
Are you planning on running SQL 2008 on Windows 2000 or are you planning on upgarding the OS?
Generally 2008 will require resources, as it has more capabilities.
The default server trace takes up resources.
Enforcing policies uses resources.
Processing a logon trigger uses resources that were not required for SQL 2k
Partitioning uses more resources than just dumping the data to a non partitioned table.
TDE and compression use much more resources.
I could probably go on and on.
If you are just going to use the database engine in the same manner as you are for 2000, then you could probably run it, but I certainly would not recommend it. I also would not really even consider trying it in a production environment without first testing on similar hardware/os in a QA environment. I would definately not put my job on the line that I could upgrade and get the same or better performance. So can it be done, yes. Will it be better or worse, I would not lay a bet on that proposition.
Then there is just the basic concept that it's nine years newer, thus is designed for current hardware, not legacy hardware (try installing Windows 7 on a PC that was purchased in 2001)
/* ----------------------------- */
Tochter aus Elysium, Wir betreten feuertrunken, Himmlische, dein Heiligtum!
March 27, 2010 at 11:28 am
Planning to upgrade OS to 2003 Server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply