Post reply

Performance Comparison SQL 7 & 2000

  • September 21, 2005 at 8:06 am

    #95250

    Hi Folks - I'm looking for any articles or personal experiences regarding the performance differences between SQL 7 & 2000. 

    Basically, if we keep the hardware and operating system the same and upgrade from 7 to 2000, what magnitude of performance increase should we be expecting?  Assume that the database structure, stored procs, views, etc won't change.

    I've searched the forms but couldn't find what I'm looking for.  There are feature comparison links out there but that isn't what I'm looking for.  Thanks!

  • September 21, 2005 at 10:36 am

    #591890

    Jason,

    I've upgraded a few and query performance didn't seem dramatially different. The tools were better and backups seemed faster, but I don't have an objective look right now.

    One good reason is that the two platforms work pretty much the same, but 2000 is like a 7.5, more refined and cleaner and mature. Also it's supported and 7 is done or nearly so. you could upgrade your license to 2005 in Nov and still just upgrade to 2000. That would prepare you for the future when you were ready to move to 2005 and keep costs at a reasonable place.

  • September 21, 2005 at 11:33 am

    #591921

    Thanks Steve. 

    The reason I ask is that we've got an application that is pushing the processors on the existing hardware and they need to decide either to just upgrade the software versions or to buy new hardware and do the software upgrade.  They aren't maxing out the resources but pushing it just hard enough that it affects the users.  If they buy the hardware, the software upgrades will need to be done because NT isn't compatible with the new hardware that we would buy.  We'll also force the new versions of SQL and IIS at the same time.

    The old system is NT4, SQL 7 and IIS 4.  The new system would be Windows 2003, SQL 2000, IIS 6.  I know we are going to get performance increases from the upgrades but I don't know what the cumulative effects would be. 

    Since NT doesn't support hyperthreading and W2K3 does, I think we'll get better use of our processors (dual 2.6 Ghz).

    I'm trying to look at the individual effects of each software component.  This won't tell me how much improvement I'll actually get, but it should give me an idea. 

  • September 21, 2005 at 1:21 pm

    #591987

    Perhaps the upgrade of the application has some optimisations that aren't so hard on the cpu? (improved queries ...)

  • September 22, 2005 at 1:45 pm

    #592384

    An upgrade to Win 2K3 alone should boost your performance (more efficient OS and the hyperthreading). However I'd go to SQL 2K as well since things are much more 'stable' in some areas. I remember all too well trying to cluster on v7, replicatin headaches and a SQL Agent that crashed more than there were hours in the day ! Also given your current config SQL and IIS together, I'd make sure that you have 4 Gb of RAM at least --> 2 Gb for SQL Server, 1 Gb for IIS and 1 Gb for Windows.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • September 22, 2005 at 1:54 pm

    #592387

    Thanks folks.  We will be moving to SQL 2000 as well.  Unfortunately the vendor application doesn't have any new optimizations as Jo had mentioned. 

    There is 4 GB of RAM and about 1.5 GB of that is free on average.  I think this is the first SQL server that I've come across that has hit a CPU bottleneck before a memory or disk bottleneck. 

    Good new though, the vendor made a parameter change in one of their jobs and reduced the CPU utilization by about 20%.  Now they are only processing data that they need!  Don't get me started on that....

  • September 22, 2005 at 1:58 pm

    #592389

    No let's get you started on that .

  • September 22, 2005 at 2:23 pm

    #592400

    We need a 'war stories' category ... I'm sure there would be lots of contributions ... not to mention 'spirited' discussion as well ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • September 22, 2005 at 2:23 pm

    #592399

    We need a 'war stories' category ... I'm sure there would be lots of contributions ... not to mention 'spirited' discussion as well ...

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • September 22, 2005 at 2:39 pm

    #592402

    A 'war stories' category would certainly be entertaining.  No doubt we can learn a lot from each other's struggles and misfortunes as well. 

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply