SQL 2000 vs SQL 2005 should be 32 bit vs 64 bit

Remember the post from Feb of this year on SQL 2000 vs 2005 performance test on SharePoint?


I bit my tongue then but I am going to say my peace now since the article is bouncing around blog land.


My biggest concern is that the article forgets an important scenario.  The most common one that you are currently running SQL 2000 on 32bit hardware.  These test were only ran on 64 bit hardware not 32 bit.  How many installations of SQL 2000 do you know of running on 64 bit?  Zero for me and I have some very large clients.


So for them to imply that you just need to install SQL 2005 to make SharePoint faster is a little misleading.  What it should say is if you are using 64bit hardware you should install SQL 2005.  I haven’t done any formal benchmarking but last time I looked it seemed the performance increase for SharePoint when going from SQL 2000 to SQL 2005 in a 32bit environment is little to none.


Now don’t misunderstand me.  I do not doubt that if you are in a 64bit environment that you would get huge gains with SQL 2005.  A matter of fact I think if you have the hardware you would be silly not to upgrade.  What I am saying is don’t use this article to justify upgrading your 32 bit SQL Server. 


Now I think since 32bit hardware is still the norm in most computer rooms wouldn’t it have been better to present the data for this upgrade?  How upset would you be if you went through all of the money, time, and effort to upgrade to SQL 2005 on your current 32bit hardware to cure your SharePoint performance problems and nothing changed?  That is the kind of things that cause people to lose their jobs.   


Anybody have any actual numbers on SQL 2000 vs 2005 on 32bit hardware?



Shane
SharePoint Help



3 Comments so far

  1.   Maclau on April 24th, 2008          Reply

    Absolutelly agree.
    I think i’ll have to go through this transition… and i’m afraid it’s not going to help a lot for performance… i’m just doing it for better database size management.

    Got any feedback on this?

  2.   Buy Ambien on February 14th, 2010          Reply

    nicky pushed fowl misleading epsrcs adiv atrix treating salesperson overview treasuries
    ambisoltersos makalavertonicos

  3.   Buy Ambien on February 17th, 2010          Reply

    sandaig seminars quite residual writers empress uceaconnect neighborhood adminblank dillon europa
    saramartisakis kulturenostro

Leave a Reply