question

askmlx121 avatar image
askmlx121 asked

upgrade or buy new?

hi We have windows server 2003,32 GB ram and 700 GB hard disk, 2 processors of dual core Xeon, SQL Server 2005 SP4. but it has already 4 years old. My question is whether buy new server is it better or upgrade the 2 processors to latest is it better? Kindly suggest me........ if buy new Server is better option ... means....give the list of optimized latest Server list.......
sql-server-2005server
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image
Kev Riley answered
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
Sorry I don't know all the latest servers.
3 Likes 3 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
And why should you be expected to? Server hardware is always changing, and generally you would only take a particular interest when you are looking to buy a new server...
3 Likes 3 ·
askmlx121 avatar image askmlx121 commented ·
At least give new latest server list.........
-1 Like -1 ·
Usman Butt avatar image
Usman Butt answered
You have been given great starting points from Kev Riley. But seems like the reason for upgrade is a bad choice. That should really depend upon the usage and workload on your server not upon how old the server is. We have been running 7 years older servers and some of them are still under utilized. So for us there is no need at all to change them OR upgrade any hardware. But if you are facing hardware limits and current workload cannot be handled by the server, then first step would be investigate the root cause. If it is the memory issue, then upgrade the memory. If it is the processor then upgrade it and so on. But first thing is to find the root cause. You may not have to upgrade anything if long running queries, no indexes, unnecessary indexes etc. can be taken care of. I always find it hard to get a new server as compare to upgrading OS or SQL Server. Please always keep in mind that you would be in a very awkward situation, if you did upgrade the hardware/server and found zero or minor improvement only. Just my two cents.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Fatherjack avatar image
Fatherjack answered
I guess it is likely that you are approaching the end of your manufacturers warranty*, this may affect your decision to renew it or not. When buying new buy the best you can afford, looking to use the guide referenced in the other answer as how you might best purchase the specification that meets your needs. Lots of drives, lots of RAM and as many processors as you can license. Keep in mind that SQL Server 2012 will need to be licensed by CPU core when you install it and buying new hardware now means that at sometime in its lifetime your will be installing SQL 2012 on it. On our hardware we get 5 years before they refuse to support old hardware.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.