Slashdot Mirror


MS Squashes SQL Benchmarks

Player To Be Traded Later writes: "Robert Cringely at Infoworld reports here on Microsoft's attempts to squash SQL Server 7 benchmarks." In short, when a testing lab came up with far better results for SQL Server 7 under Windows NT than with its much-touted successor Windows 2000, Microsoft decided they'd rather keep the touting nice and quiet.

127 of 336 comments (clear)

  1. Re:I can't say I blame them... by Trepalium · · Score: 3
    Not to mention that you may well also have to upgrade/fix whatever application you use with the SQL server, since there's usually enough differences/bugs in each new version that you need to rewrite or fix the affected parts.. There could be a lot of different reasons why you'd want to use MS SQL 7 with Windows 2000. If there's a legitimate performance problem with MS SQL 7 with Windows 2000, Microsoft should fix it instead of telling people that they should be using SQL Server 2000 instead. In some cases, it's just not possible.

    Microsoft has made a lot of noise about how Windows 2000 is faster than Windows NT 4.0 in their efforts to sell it to businesses that don't really want to upgrade. Denying that this exists without generating some proof that it doesn't won't help them.

    --
    I used up all my sick days, so I'm calling in dead.
  2. No bias here by graniteMonkey · · Score: 4
    an independent testing lab from publishing benchmark results that the lab ran for InfoWorld's sister publication NetworkWorld


    Hi, my name's Robert X. Cringely, and this is a completely impartial article.
    --

    This is a manual virus. Copy it to your sig and help me spread!
  3. Re:Squash? SQUASH??? by tgeller · · Score: 2
    Ooo, "quelch" works, too. Good one.

    My desk dictionary (Webster's New World, 3rd College Ed.) gives the following definition for "squelch": "The act of suppressing or silencing, especially a crushing retort..." "Quash" is given a stronger definition: "To annihilate, destroy...".

    I was thinking the jargon "squelch" (as used in audio technology circles), to eliminate signal output that's below a certain threshhold. Strangely, my dictionary doesn't give that definition.

    Anyway, the point is obvious: Slashdot would be well served by having at least one professional editor looking at the text before it goes out.

    --Tom

    --
    Tom Geller
  4. Re:Learn from your mistakes and admit it by tswinzig · · Score: 3

    If they don't like the test results, they say the test was illegal and it doesn't count(They did this a while back with a few Linux vs. NT tests too).

    Wow what a horrible bit of "evidence" to drudge up, since the same thing happened in reverse when some Linux benchmarks showed it performing worse than NT. The Linux crowd went berserk...

    One thing I've learned over the years -- the only benchmarks that matter are ones you do yourself with real-world situations!

    If you can't do them yourself, then you just have to take third party benchmarks with a mill of salt.

    --

    "And like that ... he's gone."
  5. What about DOS? by SpanishInquisition · · Score: 4

    I'm sure MSSQL would go pretty fast on DOS 6.2

    --
    Je t'aime Stéphanie
    1. Re:What about DOS? by reynolds_john · · Score: 2
      I've been running SQL Server 7 on PCDOS 7.0, and my TPC Benchmarks rival that of Oracle/DB2!!! We've posted our results to Microsoft and run internal competitions with SQL Server 2000 running on Win2k Datacenter - but SQL 7 with DOS just simply outpaces them all.

      We're readying terradata-sized data warehousing.... now we just need to figure out a way to partition out our database into 2.1 gig fat partitions and drive letters (the hallmark of any 'real' operating system!).

    2. Re:What about DOS? by be-fan · · Score: 3

      How the f*ck is this flamebait? DB's are basically OSs in themselves, given how much of their own memory allocation and FS stuff they do. They're basically the only reason raw I/O exists at all. Since DOS has no real overhead, I wouldn't be surprised if a database performed faster under DOS.

      --
      A deep unwavering belief is a sure sign you're missing something...
    3. Re:What about DOS? by HiThere · · Score: 2

      Wasn't this sort of what Oracle was planning to do? Possibly without even the DOS, but one of the nice things about dos is that you can just get rid of it after booting, so that shouldn't be a limitation.

      OTOH, I don't know which version 6.2 is. Perhaps that's one of the versions that only run embedded in a Win32, if so then that is an esoteric funny comment.


      Caution: Now approaching the (technological) singularity.

      --

      I think we've pushed this "anyone can grow up to be president" thing too far.
    4. Re:What about DOS? by jovlinger · · Score: 2

      Apparently this is pretty much how Netware works. ( and they get pretty good numbers for file sharing performance on modest hardware)

      IF you have a hugeass (== $$$) DB system, you can probably get away with only supporting a very limited set of hardware configs. Putting everything in what is effectively the kernel probably helps ALOT.

  6. Re:Why do DB companies get away with this? by bnenning · · Score: 5
    If I go to the store, purchase a copy of the program, and install it without agreeing to the EULA, I can still legally run it (MS has been compensated; there's a provision in 17 USC that excludes the running of software from infringement)

    That's very interesting, and appears to be correct (see http://www.cybercrime.gov/ipmanual/03ipma.htm, "Statutory exceptions" section). I was under the impression that the entire EULA mess started because a clueless and/or bought judge ruled that loading a program into RAM constituted making a copy. Under that (il)logic, the EULA grants you the right to run the software which you would not otherwise have, and in exchange strips you of fair use rights. But based on 17 USC, you already have the right to run the software, so the EULA removes your fair use rights in exchange for nothing. IANAL, but I thought that a contract without "consideration" was invalid. So even if a EULA is a contract (highly questionable, given there's no communication between you and the manufacturer and no way to prove you actually read and agreed to the terms), it shouldn't be enforceable. Can anybody clear this up?

    I'd like to see the EFF take up the EULA issue, of course only after they've finished sending the DMCA back to the bowels of hell from whence it came.

    --
    How to solve most of our problems: 1.Lots of nuclear plants. 2.Cure aging.
  7. Why does MS bother? by garcia · · Score: 2

    I find it interesting that MS would continue to squash things. They already squash all their competition, now they are squashing their own stuff!

    1. Re:Why does MS bother? by Pig+Hogger · · Score: 2
      I find it interesting that MS would continue to squash things. They already squash all their competition, now they are squashing their own stuff!
      If only they would squash their own bugs...

      --

  8. Re:Why do DB companies get away with this? by sheldon · · Score: 2

    That does make sense.

    The whole notion of EULA and shrinkwrap licenses doesn't appear to have been fully tested in a court of law.

    I do think it's about time for this to happen.

    Then again with UCITA will it really matter?

  9. Re:Big Deal by sheldon · · Score: 2

    What most recent round?

    As far as I have seen the only web server which has shown higher numbers than IIS has been tux. Not apache.

    Apache just has too much overhead to compete in that realm.

  10. Not all the big RDBMS makers ban benchmarks by tjwhaynes · · Score: 2

    the big DB companies all ban publishing benchmark results through terms in their license agreements. This is incredibly irritating because it undermines the free market principle of "perfect information" (markets with "asymetric information" are known to be ineffecient, something laissez-faire Randites never seem to learn).

    This would be bad if it were totally true. Oracle has benchmark clauses in its licence agreement. So does MS SQL Server. But DB2 UDB does not - take it, download it, play with it and publish the results. Not being able to publicize benchmark results is a really dumb way to try and tilt the market.

    Note: I'm a developer for DB2 UDB so I'm hardly unbiased.

    Cheers,

    Toby Haynes

    --
    Anything I post is strictly my own thoughts and doesn't necessarily have anything to do with the opinions of IBM.
  11. There are two kinds of people in this world... by Anonymous Coward · · Score: 4

    I love to see a Microsoft article go up, then observe the huge disparity in responses. Overwhelmingly, you see the two categories into which everything in the universe can be divided: 1)High school aged rabid Lunix advocates who are drooling all over themselves to get in a slashbot comment for the purposes of karma whoring, and 2)People who have jobs, earn money, and invariably have/want to work with Microsoft products. Granted, not all people who are outraged at this are making the same frothing response, but those of the former who do so are rewarded for their "cleverness" just as well as those from the latter who see that this is both typical behavior for any database vendor and wholly unsurprising to those who know squat about Windows. Of course those who are in their little "Yay Linux" world are predisposed to ignorance on the topic.

    1. Re:There are two kinds of people in this world... by WNight · · Score: 2

      As opposed to everyone who says "Oh, pity me, I will lose karma for saying this, but ... MS might not actually be the devil. Linux might not rule the world."

      Those are straw men. Few people hate MS, most just hate MS's tactics.

      If MS is abusing the legal system, they deserve to get slammed. I'd feel the same no matter who was trying to control my ability to comment on a product I used.

      People merely want MS to have to follow the same rules as other businesses in other markets.

  12. Re:We are MS, we need no independent ratings! by 1010011010 · · Score: 2

    How dare you try and subject us to such Consumer Reports drivel!!!


    You've hit the nail on the head. We should all politely ask our friendly neighborhood legislators to enact a law protecting the publication of "consumer reports drivel." Consumer Reports performs a very valuable service -- testing and reporting and products objectively (i.e., without any marketing hype or bias for their own pet products). Many people consult CR when buying a car, dishwasher, etc. So why not for software?

    - - - - -

    --
    Napster-to-go says "Fill and refill your compatible MP3 player", which is a lie. It's not MP3. It's WMA with DRM.
  13. Re:Learn from your mistakes and admit it by Saint+Nobody · · Score: 2

    yes, their second test was fair, and revealed problems. I never disputed that. but that first test was essentially rigged in favor of nt, and there's no denying it.

    --
    #define F(x) int main(){printf(#x,10,#x);}
    F(#define F(x) int main(){printf(#x,10,#x);}%cF(%s))
  14. Re:Learn from your mistakes and admit it by Saint+Nobody · · Score: 2

    I really find it hard NOT to have a problem with benchmarking NT as tweaked out as they had it (4 NICs and 4 processors, 1 NIC bound to each processor with separate stacks as i recall) with an out of the box Red Hat installation.

    --
    #define F(x) int main(){printf(#x,10,#x);}
    F(#define F(x) int main(){printf(#x,10,#x);}%cF(%s))
  15. Re:What the hell? by 1010011010 · · Score: 2

    Yeah, that must be the article, seeing as how it's about NICs and network throughput, which are obviously code words for "SQL Server" and "Windows 2000".

    - - - - -

    --
    Napster-to-go says "Fill and refill your compatible MP3 player", which is a lie. It's not MP3. It's WMA with DRM.
  16. Re:Mistake or no by Arandir · · Score: 2

    Hee hee. Netscape enjoyed for a while the benefits of monopoly (if that's the word people want to use). But like all monopolists, they got fat and lazy and some upstart came along and made a better product.

    The same thing is happening now to Microsoft and its monopoly (if that's the word). They got fat and lazy. And along comes the upstarts with Linux, BSD, Konqueror, Mozilla, KOffice, OpenOffice, KDE, GNOME, Eazel, yada, yada, yada.

    I have no problems with "natural" monopolies. They got there because of the market, and the market is all too willing to take them out if they get uppity. Soon you're going to see Microsoft dissatisfaction hit critical mass and hell's going to break loose...

    --
    A Government Is a Body of People, Usually Notably Ungoverned
  17. Re:Big Deal by Arandir · · Score: 2

    So? Don't use their software! Is it that difficult of a concept?

    Your freedom is up to you, and you alone. But beware, freedom is not convenient and easy. It is difficult and irksome.

    --
    A Government Is a Body of People, Usually Notably Ungoverned
  18. Re:I can't say I blame them... by teg · · Score: 2

    Saying it's "slower" isn't that accurate:

    1. The architecture can run at higher speeds - that is one of the big benefits of the new architecture. The old one can't go any further, as demonstrated by Intels's attempt at 1.13 GHz
    2. It has different speed characteristics - it's plenty fast enough for the standard applications, but is much more powerful where the current bottlenecks are: It has a much higher memory bandwith and very good performance for streams of data.

    That aside, everything isn't perfect with the P4: It really needs a silicon shrink, and going with RAMBUS hurts it badly. It's by rambus, it's expensive and you could get as much performance by using DDR SDRAM and/or multiple memory interfaces. It's also rather expensive - I just bought myself an Athlon, and is happy with that.

  19. Re:You mean *some* db companies... by small_dick · · Score: 2

    yeah, i guess i've never considered the free ones "companies", but you certainly have a point.

    there is a tendency in free software and open source along the lines of "BRING it on -- find the problems -- we'll fix 'em" that is kind of refreshing.

    i try to bring that spirit with me to my meetings...

    --


    Treatment, not tyranny. End the drug war and free our American POWs.
    See my user info for links.
  20. Fair use can be contracted away by yerricde · · Score: 2

    Under standard copyright law, something like benchmarks is considered fair use, and is thus not subject to asinine click through agreements. If something is not covered by copyright law, it cannot reasonably be covered by click through

    Click-through is like any other contract. Once you agree to it, you are bound by it. The agreements already waive your first sale rights. If you waive fair use, you waive fair use; such are the terms of the agreement. If you don't like it, tough beans. Use free software instead.


    All your hallucinogen are belong to us.
    --
    Will I retire or break 10K?
    1. Re:Fair use can be contracted away by blakestah · · Score: 3

      Click-through is like any other contract.

      Click through is governed by copyright. As eminent proof, I can extract the usable binaries from packages I purchase for most commercial software without clicking through. I guess that makes me a thief in the US (do to DMCA). Or does it ?? Click throughs do not protect copyrights - they attempt, illegally, to extend them.

      I might feel differently if they actually asked me to click through BEFORE I write a check. They ask you to agree to a license that governs something, and you cannot see the license before you make a purchase. Of course they give you the right to demand a refund, but do you remember the protests in which consumers demanded refunds for Windows ? It is a big ball of wax shined on to convince you that you do not have rights you have. Very few things about click throughs meet the standards to be called a contract.

      The software has only copyright, and copyright has fair use. Evaluating and posting public commentary on that use is one of the most standard protected forms of fair use.

  21. Re:a way around the "no benchmark" rules by 1010011010 · · Score: 2

    markets with "asymetric information" are known to be ineffecient, something laissez-faire Randites never seem to learn

    Eh? The correct term is "Randroids." Randroids, like communist pinheads, coffee-shop liberal-arts 'revolutionaries' and James Carville,
    have it all figured out.

    Then, there's the people who read Rand and think about it, and realize that when she wrote, don't accept things on faith; think about them yourself she was talking about objectivism as well.

    There's a great bit in the Illuminatus! trilogy about a painting, showing God looking down and pointing his finger at the viewer, with the legend, "Think for yourself, Schmuck!"

    And, if you stop to think for yourself, you'll realize that markets without information are not "free markets" but "captive consumers" and possibly "old-time snake oil fraud."

    David Brin has a semi-good book called The Transparent Society, where he discusses why people tend to always think that reducing information flow will fix their problems, when, quite often, increasing information flow is actually what needs to be done. He also discusses the notion of "reciprocal transparency"; meaning, when you must disclose information about yourself to another party, demand a reciprocal disclosure. For instance, you can go to sites like 123nc.com and look up people's criminal records; I think that that could be fine, but whenever someone accesses my records (if I had a criminal record), that I should recieve free written notification on a standard form of who accessed what, when. Same thing for credit agencies -- when someone runs a credit report on me, I get notification of that fact, and maybe even a copy of their credit report to boot. At their expense, of course -- they initiated it!


    - - - - -

    --
    Napster-to-go says "Fill and refill your compatible MP3 player", which is a lie. It's not MP3. It's WMA with DRM.
  22. Re:Bloat by graniteMonkey · · Score: 2

    Here's a nice example of the bloat for y'all. Try those benchmarks on a properly configured system.

    --

    This is a manual virus. Copy it to your sig and help me spread!
  23. Comment removed by account_deleted · · Score: 2

    Comment removed based on user account deletion

  24. Re:Why do DB companies get away with this? by 1010011010 · · Score: 2

    Does the Ford accelerate at 9.8m/s^2?


    When dropped from an airplane, yes. After all, the Fuckers only run downhill, there's no bigger hill than straight down, and those Ford fans like for their cars to run fast! :)

    - - - - -

    --
    Napster-to-go says "Fill and refill your compatible MP3 player", which is a lie. It's not MP3. It's WMA with DRM.
  25. Re:Mistake or no by divec · · Score: 2
    Microsoft never browbeat Netscape into the ground. They just had a better browser. Plain and simple.
    Why don't you read the relevant section of Judge Jackson's finding of fact? Among the things they did were to *force* computer vendors to leave the IE icon on the Windows desktop, even if they didn't want to. They excluded Netscape from the most profitable sections of the market. When you have a monopoly, that is illegal.
    I hate it when people misconstrue facts to make it sound like MS did dsomthing bad when it comes to Netscape
    Hmmm. IHBT IAHAND I think. At least, you don't appear to have read the finding of fact. You may disagree with the conclusions but you can hardly say that it "misconstrues facts".
    --

    perl -e 'fork||print for split//,"hahahaha"'

  26. Re:Yeah, M$ is getting *killed*!! by Arandir · · Score: 2

    Weird, 'cuz the Linux and BSD marketshares are also on the rise. Before you know it the combined marketshare of all platforms will be 568%!

    There's lies, damn lies and statistics. Yournumbers don't include some important information. Like how the total market has grown. I suspect that their increased marketshare is due to brand new computer users, rather than 30 year Unix veterans switching over to Windows. Brand new computer users don't choose Linux. They choose what the majority of their neighbors are using.

    --
    A Government Is a Body of People, Usually Notably Ungoverned
  27. Interesting by Anonymous Coward · · Score: 2

    How is this any different than a totalitarian regime (i.e., China) monitoring the news and only allowing certain material that they deem "suitable for public consumption" to reach the masses? Microsoft has long said that their products are superior to their competition (Oracle, IBM, Linux, etc.) This type of censorship is stomach-turning. Come on, Microsoft, if you really believe your own press then there is no reason to supress the rights of free individuals in a free country to honestly and independently evaluate your product.

    1. Re:Interesting by memfrob · · Score: 2
      This type of censorship is stomach-turning.

      If you don't like the license, don't use the product. As a matter of fact, point it out to your friends and peers, and ensure that they don't use the product, either. If you get bitten by the license clause of a product that you used anyway, you've only yourself to blame.

      I'm certainly not defending the practice; I don't agree with it one bit. But perhaps the reviewers should have posted their review as:

      "We would have reviewed this product, but Microsoft is not confident enough to let us perform an independent test without their approval of the results, so we simply just don't recommend buying this product. 0/5 stars."

      --
      The Wizard utters the word 'frobnoid!' and cackles gleefully
    2. Re:Interesting by cyber-vandal · · Score: 2

      Except that they are a totalitarian monopoly that will take years to move. When you're a monopoly you can do anything to your customers and they can't do a damn thing - like British Telecom over here in the UK.

    3. Re:Interesting by Rick+the+Red · · Score: 2
      there is no reason to supress the rights of free individuals in a free country to honestly and independently evaluate your product.

      You missed the point. They cannot and do not suppress anyone's right to "honestly and independently evaluate" their products. They just suppress your free speach rights to tell anyone what you found. You're free to say "We evaluated MS SQL and Oracle and chose Oracle because we feel it blows MS off the map", you just can't say how much it blows.

      --
      If all this should have a reason, we would be the last to know.
  28. Re:Transaction Processing Council by vidarh · · Score: 2
    The point is they should be allowed to publish bullshit, and Microsoft should criticize them on the merits of their work, not threaten them with lawsuits over it.

    If Microsoft can really demonstrate that the testing labs methods are flawed, and that the benchmarks they publish are useless, then fine.

  29. We are MS, we need no independent ratings! by slashbrent · · Score: 2

    Hi, where would like to go today?

    What is that you ask? Are we the best product for you? How do we rate against others? - Trivial questions my friend, for we are the Bor..i mean Microsoft and Resistan..er, our products are Right For You (C) no matter who you are.

    Did i mention that we are the biggest software company on Earth? How dare you try and subject us to such Consumer Reports drivel!!!

    Sincerely, Bill Gates

    --

    Moderators need an additional choice: "Karma Whore" for people who cut-and-paste articles as their comments!
  30. Doesn't matter by kahuna720 · · Score: 2

    The PHB's and People In Charge will be unaffected anyway, since they'll just go ahead with whatever "Solution" Microsoft forces on them, regardless of merit or test results. Even if this got a great deal of publicity, I don't see it changing anything on either the pro- or anti-MS sides, because both camps already have their mind made up (or had it made for them by the software licensing their company has agreed upon).

    Plus, we've seen such reactions to benchmarking results from MS before, and it didn't really seem to affect their market share...

    --
    props to all dead homiez
    1. Re:Doesn't matter by dachshund · · Score: 2
      The PHB's and People In Charge will be unaffected anyway, since they'll just go ahead with whatever "Solution" Microsoft forces on them, regardless of merit or test results.

      Not necessarily. MS doesn't own this market-- there's a lot of competition, and the Win2K release has been something of a failure. I know plenty of People In Charge who are dubious about Win2K because on their personal machines it runs like a pig, and that doesn't inspire confidence from even the densest boss.

  31. Re:Yeah, M$ is getting *killed*!! by Zico · · Score: 2

    But you were implying that Microsoft was having trouble because of the KDEs and GNOMEs of the world. How do you reconcile your statement with the fact that they're increasing their desktop marketshare? (For the record, the two closest competitors were MacOS at 4% and Linux at 1%.) And BSD? Come on.


    Cheers,

  32. Learn from your mistakes and admit it by alptraum · · Score: 4

    Typical Microsoft response. If someone else has a technology that could damage them, they buy the company and hide the technology to collect cobwebs. If they don't like a company, they browbeat them into the ground(prime example, Netscape). If they don't like the test results, they say the test was illegal and it doesn't count(They did this a while back with a few Linux vs. NT tests too). If the test results come back bad, MS should see it as where they came short this round, but to accept and try to fix in the future. Learn from your mistakes, don't cover them up and lie about the matter.

    1. Re:Learn from your mistakes and admit it by ignavus · · Score: 2

      The Linux crowd may have gone berserk, but it never suppressed the result.

      We may be obnoxious, immature, ill-informed and unreasonable, but there is no Linux marketing department with the power to say that the publication of truth is a breach of your EULA.

      You are not comparing like with like.

      --
      I am anarch of all I survey.
    2. Re:Learn from your mistakes and admit it by be-fan · · Score: 2

      Ahem, Mindcraft. It's a sad fact, but the majority of people have that reaction. Some, when they see bad news, try to hide it, others try to fix it. The only difference between the Linux and MS communities in this respect is that at MS, the former are in charge, while with Linux, the latter are.

      --
      A deep unwavering belief is a sure sign you're missing something...
    3. Re:Learn from your mistakes and admit it by be-fan · · Score: 2

      Let's not repeat this again. Mindcraft revealed REAL problems with Linux on high end hardware. These issues were duly noted and fixes have/are being done. Have a bad experience and learn from it. If you actually have 4 procs and 4 NICs, then you're happy that Linux now scales to that level, and the prodding by Mindcraft didn't hurt any in this respect.

      --
      A deep unwavering belief is a sure sign you're missing something...
    4. Re:Learn from your mistakes and admit it by Anonymous Coward · · Score: 2

      Typical uninformed slashbot bs. SQL 7 on NT vs SQL 2000 on W2K would have been a fair test. I dont blame MS for squashing incompetence anymore than I'd blame Linus for giving up the ghost on this Linux nonsense.

    5. Re:Learn from your mistakes and admit it by darkonc · · Score: 3
      NT vs SQL 2000 on W2K would have been a fair test.

      If that were the case, I would expect that Microsoft would have mentioned it in the week that they took in trying to find a resolution.

      In any case, if this is at all indicative of how software fares on W2K when moved from NT4, then they should be printing a warning on their box that NT 4 software could run as slow as half speed on their newfangled OS.

      If nothing else, SQL customers who are thinking of movingto W2K would be well off to know these results before they upgrade their OS, rather than after. Otherwise they could be caught with their pants down after an upgrade seems to go cleanly and then bogs down horribly once the queries get back up to production volume.
      --

      --
      Sometimes boldness is in fashion. Sometimes only the brave will be bold.
    6. Re:Learn from your mistakes and admit it by Trepalium · · Score: 2

      It's been said that there are three types of lies.. Lies, damn lies, and benchmarks. For some strange reason, though, people have always put far too much faith in the results of benchmarks. There's all sorts of different tradeoffs with each product. Even a product with the worst raw performance can have many other factors that make it the only real choice.

      --
      I used up all my sick days, so I'm calling in dead.
  33. Yeah, M$ is getting *killed*!! by Zico · · Score: 2

    They've only gone from an 89% desktop marketshare to 92% over the past year. Not only that, but they've only gone from a 38% server marketshare to 41% over the past year! Those poor bastards!


    Cheers,

    1. Re:Yeah, M$ is getting *killed*!! by Arandir · · Score: 2

      Microsoft is increasing marketshare amongst newbies. A first time computer user is going to choose what most of his neighbors and friends are using. I want to know how many Microsoft customers in 1995 are still Microsoft customers in 2001. I want to know how many 30 year Unix veterans admitted defeat and went to NT last year.

      --
      A Government Is a Body of People, Usually Notably Ungoverned
  34. Fake benchmarks by PepsiDman · · Score: 4

    Keeping quiet about statistics is the best way to lie about them - This is just the same as the old toothpaste advertisments, that 'made 9 out of ten children have fewer fillings' - The results that the toothpaste company did not want seen were simply filed quietly out of sight. Companies releasing desired stats (and witholding undesirable ones) is nothing new... Its a simple fact :) There are lies, damn lies and then statistics; or in this case, Benchmarks :)

  35. Re:but i digress by joss · · Score: 2

    You make some good points, except there are java VMs for cell phones, and Amiga is the name of a computer as well as a company.

    The main thing wrong with the (3) sentances is that their "astute" readers are wrong on several levels, first - just because something is meant to be platform independent doesn't mean it is, secondly there is no such thing as a platform independent language. It's the instruction set and the operating system that matter - Java is platform independent by virtue of the fact that it runs on a mini OS (which it calls a VM) that has been ported to run on other OSs. The other side is the instruction set, and it's quite possible that the VM hasn't been optimized for P4 yet, ie the VM optimized for PII architecture runs very slowly on P4, which is probably what the Intel exec meant - that would be interesting news.

    --
    http://rareformnewmedia.com/
  36. Re:And the point is? by Znork · · Score: 2

    Actually, the point is; thats what 'commercial support' is worth.

    Pay loads for incompetent support that cant help you and who will then proceed to threaten to sue you if you tell anyone how bad the products are.

    And if you cant switch support vendor, well, congratulations. You lose.

  37. Re:And the point is? by RedWizzard · · Score: 3
    SQL Server is the fastest database server in the world.
    That's impossible to determine from the TPC benchmarks because the hardware is too varied. It's even worse than the SPEC benchmarks. TPC numbers are only useful for evaluating the specific setups they've measured and there aren't many of those.

    For example, compare the top result (Compaq/Win2K/SQLS2000) with the fifth result (IBM/AIX4.3.3/Oracle8.1.7). Both systems cost around $10M. The Compaq cluster scores about 2.3 times higher than the IBM system. The Compaq cluster is 24 8x700MHz PIII Xeon servers (192 processors). The IBM server is a single 24x600MHz RS64 IV (24 processors). With that sort of hardware disparity it is impossible to make any judgement on the software performance at all. The Compaq setup has much better price performance but you can't attribute that to the software. The second place DB2 cluster you mentioned is a 32 machine 4x700MHz PIII Xeon setup (128 processors) and scores much closer to the Compaq setup which also points to hardware as being the major factor.

    The most interesting bit is that the software for the Compaq setup costs just over $3M, with the software for the IBM system being under $1M. Virtually all the software costs are in the DBMSs. If you have license 192 copies SQL Server is not cheap.

  38. I can't say I blame them... by km790816 · · Score: 5

    So you have a new OS out that you want everyone to run. Would you want a benchmark coming out that says your old stuff is better. I'd like to point out that this article talks about SQL7. SQL 2000 runs MUCH better on Win2k than it does on NT4.

    SQL7 was written to take advantage of NT4, not Win2k. I can't say that the test results OR Microsoft's actions suprise me much.

    1. Re:I can't say I blame them... by be-fan · · Score: 2

      It also blows goat nuts when it comes to *real* 3D performance (3D Studio), even though it costs a huge amount more than a 1.2GHz Athlon ($306 /w mobo on Pricewatch!) and isn't available in SMP. Right now, the P4 is a Quake proc, nothing more.

      --
      A deep unwavering belief is a sure sign you're missing something...
    2. Re:I can't say I blame them... by Malcontent · · Score: 2

      Interesting link. According to them the non cheating benchmarks are dominated by oracle and db/2. Considering that db/2 is actually cheaper then sqlserver 2000 for most of the common situations not a bad deal.

      BTW the top spot (IBM and Oracle) cost $9,560,594.00 who in the open source world is going to spend that kind of money for a test.

      --

      War is necrophilia.

    3. Re:I can't say I blame them... by Pfhreakaz0id · · Score: 2

      what table are you looking at? What do you mean "non-cheating" the tests are set up by the TPC ferchristsakes! Price/performance is almost ENTIRELY MSSQL!
      ---

    4. Re:I can't say I blame them... by Malcontent · · Score: 2

      By non cheating I mean actually usable database database configurations as opposed to database configurations which are designed to score high on this test and are not usable in real world situations.

      --

      War is necrophilia.

    5. Re:I can't say I blame them... by passion · · Score: 2

      Isn't that a similar story to how the Pentium 4 is Slower Than Its Predecessor?

      Gee - this upgrade every year thing just doesn't seem to be working out for these monopolistic companies...

      --
      - passion
    6. Re:I can't say I blame them... by Malcontent · · Score: 3

      You make some excellant points

      Ff you buy the SQL2K/W2K combo you will have to upgarde both your dabase server and your OS at the same time.
      The cost of the operating system should be added to the cost of the database server for a true comparison.
      Oddly this makes oracle price competitive in most circumstances how funny is that?

      --

      War is necrophilia.

    7. Re:I can't say I blame them... by Pinball+Wizard · · Score: 3
      can you give me performance numbers for SQL7/NT4.0 vs. SQL2000/Win2K>

      Let's just say they're slightly better than MySQL on Linux.

      --

      No, Thursday's out. How about never - is never good for you?

  39. who cares? use SQL 2000 instead by shodson · · Score: 5
    If they lied, yes, damn them and shame on them. However, SQL 7 was built for NT, SQL 2000 was built for Windows 2000 and is their newer product anyway.

    Also, it depends on how they had their Win2k box set up. Active Directory is a mess and could be slowing it down along with a bunch of other services that come with it by default that weren't part of NT.

  40. NT's throughput is better than 2000 by JabberWokky · · Score: 2
    Interesting... they are also "disputing" the results of Tolly Research, who found that NT outperforms 2000 in Gigabit Ethernet throughput. Check out this: http://www.nwfusion.com/news/2001/0226performance. html

    Highlights:

    A recent study by Tolly Research, the independent testing arm of the Tolly Group, found that Windows NT delivers Gigabit Ethernet throughput equal to or better than Win 2000. Tolly's finding contrasts Microsoft's testing that found Win 2000 optimized to deliver gains in Gigabit Ethernet throughput.

    Microsoft officials say Tolly's conclusions are not a fair comparison, citing variables such as client operating system, network adapters, LAN design, traffic-generating tools and methodologies.

    Tolly says Microsoft's throughput numbers may be inflated by the NTttcp packet-blasting tool it used and by testing on a highly segmented LAN. Microsoft officials admitted their LAN had two clients per segment.

    --
    Evan

    --
    "$30 for the One True Ring. $10 each additional ring!" -- JRR "Bob" Tolkien
  41. Free Speech is a Big Deal by fmaxwell · · Score: 2
    If Microsoft was using their EULA to protect company proprietary information and trade secrets, that would be fine -- and legally binding. But EULA prohibitions against publication of test results on commercial software are a violation of free speech rights and I do not believe that it would hold up in court. It's not in the interest of the consumer, the free market, or open competition.

    If such clauses were legally binding, every software publisher in the world would use them to exercise editorial control over reviews and comparisons that were unfavorable to their products. There would be no negative reviews of software and comparisons would disappear. The reason that this did not go to court is that Microsoft knows that they don't have a leg to stand on.

    The software industry is in a precarious position. On the one hand, they are attempting to get UCITA passed, which would make shrink-wrap licenses binding. On the other, if it becomes apparent that they are putting unfair and overly restrictive clauses in their licenses, UCITA would be doomed and the validity of software licenses in general could be threatened in a court battle. Or, they could realize their worst nightmare: the courts could decide software was a product. Then the no-warranty, it-may-not-work, it-might-not-do-what-we-claimed crap would be worthless. Software vendors would be under the same standards as vendors of any product and would be forced to recall products and correct flaws rather than sell you updates.

  42. Oranges are not Apples shock by kyz · · Score: 2

    can you give me performance numbers for Apples vs. Apples

    Let's just say they're slightly better than Oranges.

    --
    Does my bum look big in this?
  43. Re:Actually, you're not 100% correct by Zico · · Score: 2

    Ahh, I see. So clustering is bad if it's Microsoft doing it, but the best thing since sliced bread as long as it's not Microsoft. After all, we are at the site that's had so much gushing over Linux clustering that "Imagine a Beowulf of these!" became a running gag.

    Also, there are some pretty large holes in your logic based on what appears in the TPC-H list. Since Oracle didn't even make the list at all, your logic would also follow that "for large enterprise work, Oracle just doesn't appear to work." Pretty silly stuff.


    Cheers,

  44. A note for those who didn't read the story. by SuuSt · · Score: 5

    It should be noted that for whatever reason, be it MS backing down or the company discovering they could publish it legally, the results ARE online.

    In other words, MS didn't win that particular round.

    1. Re:A note for those who didn't read the story. by agaffin · · Score: 3
      The problem is, there is NO story, at least not about SQL Server.

      Cringely got his facts all screwed up. As you can see in our story, Tolly Research looked at Gigabit Ethernet performance on NT and Win 2000.

      Adam Gaffin
      Network World Fusion

  45. So what ??? by cOdEgUru · · Score: 2

    They didnt try to squash the benchmarks when they were done against different OS's atleast. ITs Win NT and 2000. 2000 is pretty new and they are still tuning it up, so give them sometime and they would have it running better than NT. But how about the Oracle One Million AD. If you havent heard of it, then atleast go to some website where they have put up this ad which is so much bs about nothing.

  46. Big Deal by latneM · · Score: 5

    News at 11, Microsoft enforces same license that every other database vendor uses. AFAICR, no big time database vendor would allow you to publish benchmark results, not just Microsoft. Now if they were going to allow the results to be published if the Win2K box beat the NT4 box, then you may have something.

    Besides, they left out way too much detail to get in a fuss over. Like maybe the NT4 box was a 4 way P4, and the Win2K box was a P133 overclocked to 166 MHz and with flaky 32MB simm. They never state that the same hardware was used.

    While I have never been accused of being in Microsofts corner, they are in the right on this one and we have seen darn near every major* database vendor pull the same stunt.

    *For some definitions of major.

    1. Re:Big Deal by sheldon · · Score: 2

      Of course now the question is... Is anybody but benchmarkers actually using Tux?

    2. Re:Big Deal by startled · · Score: 2

      The point, of course, is that my freedom of speech should not be limited because of any software I choose to use. No government, and certainly no corporation, should have that power.

      Unfortunately, this entire thread has degenerated into a pointless flamewar between people saying "MS sux0rs!" and other people saying "everyone who doesn't like this is just an anti-MS idiot!". *yawn* I was hoping there might be more interesting discussion about what grounds MS attempted to prevent this on, and more interestingly, how the benchmarks were later permitted to be posted.

      Of course, no one's read the fucking article, so most of them are completely unaware that the benchmarks were eventually posted. Teach me to read a /. forum-- time to go to kuro5hin.

    3. Re:Big Deal by Malcontent · · Score: 2

      Absolutely!.
      This is why free software is so important.

      --

      War is necrophilia.

    4. Re:Big Deal by Malcontent · · Score: 2

      There is a major difference here though. It's not like the magazine messed up and mis tuned the thing. When they found out that sql2K was half as slow as sql7 THEY CALLED UP MS AND ASKED FOR HELP!. Then ms and them worked for more then a week to fix the problem but they could not.

      They gave MS lots of opportunity to fix the problem but the problem was unfixable. IMHO they had a duty to report this to their readers.

      --

      War is necrophilia.

    5. Re:Big Deal by Arandir · · Score: 2

      The point, of course, is that my freedom of speech should not be limited because of any software I choose to use. No government, and certainly no corporation, should have that power.

      Your current freedom is the result of your past choices. If you chose software in the past that limits your current opportunities, that is your fault, not the software manufacturer's.

      --
      A Government Is a Body of People, Usually Notably Ungoverned
    6. Re:Big Deal by WNight · · Score: 2

      Or, use the software and publish your results.

      Their EULA is worth shit. They can claim all they want, they can't do it though.

      Why don't I just do what MS is 'asking me to do' and not use the software is I don't like the EULA? Because I don't like bullies. MS is just like that kid at school who said he'd break your leg if you told the teacher about his bullying. Microsoft is threatening to take all your money, all your future money, and level criminal charges is possible (breach of contract) if you do anything they don't like.

      Fuck em.

      Someone has to stand up to this shit.

      Microsoft isn't capitalist, they rely on government control to sustain their monopoly. If the legal system wasn't so oppressively weighted to those with money, MS wouldn't be able to compete.

      As it is, start rich (Billy boy definately didn't pay his way through Harvard) and it's really damn easy to get richer. Anyone with less money gets in your way, sue 'em and take what they've got.

      I get so fed up with MS apologists who think that MS is doing something great just because they have a lot of money.

    7. Re:Big Deal by WNight · · Score: 2

      They have no right at all to say what you do with their product, or to control your behaviour during or after your use of their product.

      Does GM get to say you can't haul Ford parts in a truck you bought from them? Do they get to say you can't go around tell people you think their truck is crap? Hell no.

      So why does MS? Just because they stick a piece of paper in the box and claim it's a contract?

      Not bloody likely.

      Their contracts aren't valid for a number of reasons. 1) You gain nothing from agreeing because you already own the software. 2) You weren't shown the contract before purchase. 3) It controls customers in a way that has been ruled unconstitutional in the USA. (I didn't idly say GM couldn't control your use of a truck. Companies have been smacked down in court many times for that crap.)

      So why is it different when they sell software? Hint: It's not. They just lie like the lawyers they are.

    8. Re:Big Deal by WNight · · Score: 2

      It's perfectly scientific. You test what you can, you report how you tested and what the results were.

      CPU Benchmarks that rely *only* on Quake 3 are perfectly valid. They show that given the test systems used, certain CPUs are better than others for Quake.

      If you use something stupid as a benchmark (SiSoft Sandra, for example) all it proves is that one system runs certain stupid benchmarks better than the other, but it does prove that.

      If they post all the benchmarking numbers, and the test suites used, then it's a perfectly valid test. A test which showed MS Access and Corel Paradox beating Oracle into the ground would be of great help... it'd prevent anyone from buying a system that was orders of magnitude above what they needed.

      But the only conclusion you can gain is that the systems, as described, are that fast at the things tested. The test results may have little bearing on performance in other areas, only a professional is likely to really be able to extrapolate accurately.

    9. Re:Big Deal by startled · · Score: 2

      What in blazes are you talking about? Under the current corporate government we have now, this particular freedom does not exist: the freedom to USE the software product AND discuss it. That is one very real, very specific, itemized freedom that has been TAKEN from you. (Well, you have the freedom, but you might be sued, tossed in jail, whatever.)

      There are lots of other freedoms that have been taken from you, such as the freedom to go around killing people. There's a very good reason for that. But what reason can you give for taking away someone's right to talk about the software they use? It sure as hell isn't based in freedom of speech, and it sure as hell isn't based in capitalism.

    10. Re:Big Deal by Arandir · · Score: 2

      But what reason can you give for taking away someone's right to talk about the software they use? It sure as hell isn't based in freedom of speech, and it sure as hell isn't based in capitalism.

      It's based on contract law. When you use Windows or Oracle, you are making an agreement with the manufacturer. License agreements are contracts. I personally don't like the implicitness of them, and would prefer explicit signed contracts, but the courts have ruled otherwise.

      By voluntarily agreeing to obey the license, you are voluntarily agreeing obey the license.

      Freedom (in the sense of liberty) is not about doing whatever you want and hang the consequences. It is about doing whatever you want with your own life, actions and property, so long as they don't interfer with the lives, actions and properties of another. If you want to do the latter you need to get permission first. That's what contracts are. And that's why laws against murder are not infringements upon your freedom.

      --
      A Government Is a Body of People, Usually Notably Ungoverned
    11. Re:Big Deal by OmegaDan · · Score: 2
      I'm sorry, but *EVEN IF* it was an unfair test they have the right to publish it. Its your job to decide wether the test was fair or not, not MS's. Microsoft skews test results in its favor all the time (remember the apache/iis affair?) so at its worst, this is no worse then what MS itself does.

      This leaves us in a bad situation, no one can publish benchmarks that show the software in a bad light, and you most ceartinly can't trust their own benchmarks.

      I realize lots of other databse vendors do this, but that dosen't make it any more or less right.

  47. Re:who cares? use SQL 2000 instead by Mr.+Slippery · · Score: 3
    Very heavy duty apps are tied very explicitly to hardware and software components.

    That may be true, but it's generally assumed that upgrading the HW or OS would therefore result in an increase in performance. This demonstrates that NT to Win2k isn't a vertical upgrade, it goes a little sideways too.

    Which is ok. It's not something that should be hidden, and certainly not something that should be censored with the threat of lawsuits based on bogus EULAs.

    Tom Swiss | the infamous tms | http://www.infamous.net/

    --
    Tom Swiss | the infamous tms | my blog
    You cannot wash away blood with blood
  48. Isn't that legal? by SuuSt · · Score: 2

    Wasn't there a law passed not long ago (it may have been the DMCA, I'm not sure), that said something about publishers having the right to force negative reviews of sites? Granted this is an "objective" benchmark (I know theres no such thing as an objective benchmark), but with a good enough lawyer, I would think MS would have a legitemate case.

  49. Actually, you're not 100% correct by dlevitan · · Score: 3
    After looking at the site, it appears that you're not 100% right. First of all, in the TPC-C benchmark the W2K computers are all clustered. Not so with the UNIX computers (none are clustered). In the TCP-H benchmark, the W2K systems are the top in the 100GB results. But they are completely overshadowed by the unix servers in the 300GB or the 1 TB results.

    So while W2K is a good OS (I personnaly use it for my desktop), for large enterprise work, SQL Server just doesn't appear to work.

    1. Re:Actually, you're not 100% correct by Malcontent · · Score: 2

      Weather or not clustering is good depend on the end result. If after you have acieved your cluster your software is usable as intended then it's good.
      The problem with microsfts idea of a clustered database is that the cluster is not usable in the real world. The MS cluster only serves one purpose and that is to score high on the TPC tests it is not usable in the real world.

      The TPC orginally disqualified the results if you remember. Then after pressure from MS they published the specs with an * (figuratively speaking) they created an entirely new category of MS and dumped the results there.

      Also note that the top performing clustered result costs about a million dollars more then the non clustered result. Paying more for a useless database configuration is an exersize that only a PHB would undertake.

      --

      War is necrophilia.

    2. Re:Actually, you're not 100% correct by Zico · · Score: 2

      Yep, the TPC originally did disqualify the results when Sun (and someone else, I think either Oracle or IBM) complained about them. However, you're incorrect about what happened next. Microsoft didn't pressure the TPC into publishing those numbers, because they were technically invalid. (Yeah, they complained that they were doing no different than all the other companies and that they were being unfairly singled out, but that's neither here nor there because they did accept the disqualification.) They performed the tests with a different setup and blew their old results (as well as IBM's, which took over first place when Microsoft's were disqualified) out of the water.

      (The top result more than doubled the non-clustered one for only $400,000 more.)


      Cheers,

    3. Re:Actually, you're not 100% correct by Malcontent · · Score: 2

      Are you claiming that a clustered architecture like the one MS designed provides the same degree of usability as a non clustered configuration?

      --

      War is necrophilia.

  50. Re:Left outer PostgreSQL? Or just PregreSQL? by hey! · · Score: 2

    So, how are they doing on the need to regularly bring the db down for vacuuming?

    --
    Post may contain irony: discontinue use if experiencing mood swings, nausea or elevated blood pressure.
  51. Re:Why do DB companies get away with this? by cpt+kangarooski · · Score: 2

    You're pretty close. The status of binaries as copyrightable was in doubt in the seventies, I understand. So EULAs were a way to prevent people from running wild with the things; they had to agree not to as a precondition to get it. Once all software was definitively granted the ability to get a copyright under basically the same constraints as anything other copyrightable work, EULAs had to take on a new function. Rather than protect publishers from users, they now had to grant users permission to make copies of copyrighted works. Without that statutory exception it is indeed murky as to whether the copies that have to be necessarily made to execute it are fair use. They pretty much are, we know, but it would take some time for the judicial system to arrive at that determination too.

    But with the statutory exception and the ability to obtain a grant of copyright in place for binaries, EULA's are generally moot. Both sides are protected by law. The additional questions of the validity of the things in general makes their continued existance even less sensible.

    I still feel that the best course of action is to not agree to 'clickwrap,' as they would seem to be the most enforcable of any of the EULAs possible, and to install software manually. One would hope that third party installer programs and scripts would appear on the scene, but most people do consider it easier to ignore the EULA and not really agree, so there's not a huge market.

    One court case to work out the details would not be advisable unless it went all the way to the top. Better to have several cases going through the system to help build precedents. (which hopefully, would be favorable, not that the lower courts are on our side these days)

    --
    -- This and all my posts are in the public domain. I am a lawyer. I am not your lawyer, and this is not legal advice.
  52. Re:try this comparison by java_sucks · · Score: 2

    Uh.... is it just me or has everyone here been tricked by the almighty Microsoft marketing machine? Lets all remember that Win 2K is actually nothing more than NT5. In fact a lot of the third party programs I run will report that when you query them for OS stats. Sure they took NT 4 and did a lot of work but the core of the OS is still NT. Repeat after me, Win2k is the upgraded version of NT4.

    Based upon how Win2k performs on my box I'm not surprised by these results though. It is considerably slower than NT 4 was on a slower machine I was using before the upgrade. Considerablly slower. However it doesn't need to be rebooted after lunch everyday to reclaim all the leaking memory like NT4 did. That's a plus. Lets be realistic here, Microsoft has never been known for caring too much about optimizing for speed, they always go for features features features, meaning bloat in some cases but always meaning you will need a lot more machine to run it properly than the previous version. I guess it has worked well for them in the past although people seem to be getting wise lately.

    I know that many of these responese are simply trolls, but it really amazes me that the marketing principle of changing a name really works, even on people who are fairly techinical. I guess they really do know what they are doing.

  53. Bad head... by DESADE · · Score: 2

    MS Squashes SQL Benchmarks

    How about a little clarity here. What is this supposed to mean? Did Microsoft try to beat MySQL benchmarks? Maybe they tried to beat their own numbers? How about:

    MS suppreses SQL Server benchmarks

    or something else that actually comminicates the meaning of the story.

  54. Crippling the OS for other benchmarks by devphil · · Score: 2


    I recall one test where MS had lined up three or four of its OSes and ran benchmarks, with the obvious marketing goal of "proving" that their latest OS was the best.

    Except that they specifically instructed the testing lab to disable direct memory access for (I think) NT, it order to make it run way slower.

    --
    You cannot apply a technological solution to a sociological problem. (Edwards' Law)
  55. Re:Bloat by cyber-vandal · · Score: 2

    Were S/390 machines banned from this test? SQL Server 2000 on shitty x86 hardware beating DB2 on the best platform for I/O. I don't think so.

  56. Squashing reviews by CyberDawg · · Score: 3

    I know it's in their license, but I have a serious ethical problem with a company being able to control "independent" reviews of their products.

    I believe that it's only reasonable for a company doing product reviews to allow the vendor to respond. If Network World puts up a review saying that SQL is slower on NT5^H^H^HWin2000 than on NT4, Microsoft should not be able to kill the review. They should be able to respond, and Network World should post the response along with their review. That's called responsible journalism.

  57. Re:And the point is? by pkesel · · Score: 2

    As a software consultant I've worked for several fortune 500/1000 companies and most had both MS SQL Server and Oracle or DB2 or who knows what. In EVERY instance it was NEVER the MS SQL Server handling the lifeblood transactions. The MS product was always handling table lookup and transitory information that was precursory to the real business transactions. This is how I gauge the real status of a database product. What do you trust it to do. Who cares how fast it is if you'd never put your business in its hands.

    --
    - Sig this!
  58. Re:OT: BMW by cyber-vandal · · Score: 2

    Until some old lady in her Volvo makes a mistake and you spend several months in traction. I used to be a biker until it nearly happened to me. I'm self-employed, I can't afford loads of time off (the insurance only kicks in after 13 weeks :-( ). My Fiat Coupe Turbo isn't quite as fast as a bike, but only supercars can beat it and I'm not at the mercy of the elements and the moronic drivers in my area.

  59. Time for a rematch? :) by powerlord · · Score: 2

    They definately revealed some real problems in a second test... I wonder how MS vs Linux would do in Round 3?

    A series of tests covering different hardware configurations...

    1) Single processor File/Print/Web/FTP server
    2) Dual processor
    3) Quad processor
    4) Oct processor (we do claim to do eight with 2.4... right?)

    I'd be real curious how 2.4 stacks up to the Y2K bug... I mean Win2K

    --
    This space for rent. All reasonable inquiries will be entertained at proprietors discretion.
    1. Re:Time for a rematch? :) by HiThere · · Score: 2

      But what's being done about the 2038 bug (do I have the year right?) except to hope that we move to 64 bit integers?

      Or, for a bit of overkill, we could use a 128 bit integer for time, set the 1 point to 01/01/0001 01:01:00.000001. And calculate in microseconds (but then we get tripped by leap seconds, irregularities in the earth's rotation, etc.)

      Caution: Now approaching the (technological) singularity.

      --

      I think we've pushed this "anyone can grow up to be president" thing too far.
  60. Re:I guess so by cyber-vandal · · Score: 2

    Whoohoo Microsoft have produced a fast and stable OS. Shame we've had to put up with 26 years of garbage before they finally managed it. Dissing Linux is silly. If Linux wasn't snapping at Microsoft's heels nothing would have changed.

  61. Bloat by Alien54 · · Score: 2
    Of course, this is not a bug. It is a feature. MS say so.

    Seriously, it looks like w2k has got a bad case of software bloat. But we should make sure that everyone knows what MS is doing. Just so that people get the appropriate warm and fuzzy feeling.

    After all, it is NOT a bug. it is a feature.

    For those interested, here is a link to the original benkmarks

    --
    "It is a greater offense to steal men's labor, than their clothes"
  62. Re:Real databases are running Solaris/Oracle. by Zico · · Score: 2

    Wow, how much did Sun pay you for that particular sales pitch? Maybe Sun would've been better off spending the money trying to figure out why those "rock solid" machines of theirs keep crashing.

    Some critics, however, argue that the problem is more serious that Sun is willing to admit. Paul McGuckin, an analyst with Gartner Group who deals regularly with major corporate customers, said that roughly 60 major Gartner clients have reported problems with as many as several hundred Sun servers.

    "There are a lot of unhappy Sun customers out there," says McGuckin, who notes that many Gartner clients complained that Sun took too long to acknowledge the problem's significance and that some believe the computer maker tried to squelch open discussion of the issue.

    Sun's Shoemaker denies any coverup, saying only that Sun initially required customers who reported the problem to sign a nondisclosure agreement because of the large quantity of internal technical information the computer maker opted to share in an attempt to solve the problem. Eight or nine months ago, when Sun realized the spontaneous-crash problem was more common than it first thought, Shoemaker says, it stopped requiring customers to sign such agreements.

    "Squelching open discussion," eh? :)


    Cheers,

  63. Where is the benchmark? by Codeala · · Score: 5

    I find it a bit interesting that the article has no link to the websites of the testing lab or the actual benchmark result...

    NetworkWorld eventually overcame the Microsoft threat, however. The test results were posted on its site early last week.

    So where is it?

    ====

    --

    Codeala - Just another mindless drone
  64. a way around the "no benchmark" rules by swinge · · Score: 5
    the big DB companies all ban publishing benchmark results through terms in their license agreements. This is incredibly irritating because it undermines the free market principle of "perfect information" (markets with "asymetric information" are known to be ineffecient, something laissez-faire Randites never seem to learn). In pursuit of the public benefit of market efficiancy, wouldn't this be a way around these stupid rules:
    1. put up a webserver with some CGIs that do some useful largescale things.
    2. Implement the same things in several CGIs that communicate with different back-end databases.
    3. Allow the public to come to the server and run and compare results (yes, you need some locking to stop them from interfering with one another).
    4. If some member of the using public is a journalist, that journalist is free to publish the results because they are not party to the license.
    5. You, a party to the license, are free to implement a website like this because it's just like any other website, albeit with a little extra redundancy.

    Slash should do it.

    1. Re:a way around the "no benchmark" rules by WNight · · Score: 2

      The biggest thing that Randites ignore is that MS and other big companies they hold up as examples rely on government control of the markets.

      If it wasn't for the government being able (and willing) to take all of your assets and toss you in jail as the result of a lawsuit, Microsoft would have a lot less power. They exist largely by suing competitors and buying the remains at auction.

      Not to mention that MS also relies on government control in the area of passing the UCITA, etc.

      We aren't in a truly capitalist society. Rand's books were just her heros vs straw men.

  65. Re:who cares? use SQL 2000 instead by gregbaker · · Score: 5
    Also, it depends on how they had their Win2k box set up. Active Directory is a mess and could be slowing it down along with a bunch of other services that come with it by default that weren't part of NT.
    The article says that the lab worked with MS "for a week" to figure things out and "neither company could fix the problem". I'm no W2k expert, but I'm sure the MS tech that work with major trade publications are. I'm sure they would have thought of turning off extraneous services.

    My guess would be that MSSQL7 uses some system calls that are "native" in NT4, but are some kind of backwards-compatible kludge in W2k. If that's the case, it would make perfect sense that MSSQL7 would be slower on W2k, but MSSQL2k would be comparable.

  66. Re:but i digress by jilles · · Score: 2

    But then, why would they? I should point out that there are java versions of the java compiler. I think jdk 1.1 used to ship with a java compiler written in java. So, if it fits in the memory of a cellphone, it can run there.

    --

    Jilles
  67. Re:who cares? use SQL 2000 instead by rgmoore · · Score: 2
    Also, it depends on how they had their Win2k box set up. Active Directory is a mess and could be slowing it down along with a bunch of other services that come with it by default that weren't part of NT.

    Of course that's hardly a ringing endorsement. "You can't get the best results with our new OS because the wonderful new features we're advertizing so much slow things down." The argument about Win2000 needing SQL2000 is plausible, but you do have to wonder whether it's really a good idea to be running software that's so dependant on the OS to get peak performance.

    --

    There's no point in questioning authority if you aren't going to listen to the answers.

  68. Re:The facts. by Zico · · Score: 2

    Wow, you're a pro at making up statistics. I got my numbers from IDC. Seeing as yours are completely fabricated, I know you won't be able to cite any sources. But since I'm such a nice guy, I'll give you the opportunity to list them now. C'mon, we're waiting — I'm always up for a good laugh.


    Cheers,

  69. Cringely track record looks discouraging... by sheldon · · Score: 2

    The past couple of weeks have not been good for Cringely.

    First the claim that Adobe Framemaker was going away, then Java won't run on Pentium IV, then this?

    But then it is just a rumor column, and you can't believe everything you read.

    It'd be nice if the actual NetworkWorld article was available somewhere to understand the specific issues.

  70. Why do DB companies get away with this? by (void*) · · Score: 2
    I could race a BM and a Ford to see who came out first, and publish the results. Why can't I do that with DB software?

    1. Re:Why do DB companies get away with this? by Gerad · · Score: 4

      IANAL, AFAIK, yada yada, standard disclaimers and all that stuff.

      The difference is that you buy a car, and then physically own it and can do whatever you want with it (within normal laws not related to the purchase of the car). You license computer software, which means that you purchase permission to use it under circumstanced stated in your license agreement. You never actually own the DB software.

      It's the basic difference why you can do so many things with tangable things that you buy, as opposed to intellectual property that you licence.

      --
      Be the Ultimate Ninja! Play Billy Vs. SNAKEMAN today!
    2. Re:Why do DB companies get away with this? by (void*) · · Score: 2
      I think this licensing issue is a red herring.

      Since the license is a contract, am I free to renegogiate the terms? Suppose I, a billionaire, want to determine once and for all whether MS SQL is faster on NT4 or W2K. Can I do this, after paying off MS, and signing a contract that allows me to publish the results?

      Just how much is this information worth, to MS? That is the question I ask.

    3. Re:Why do DB companies get away with this? by PD · · Score: 2

      Does the Ford accelerate at 9.8m/s^2?

    4. Re:Why do DB companies get away with this? by cpt+kangarooski · · Score: 5

      So what? If I go to the store, purchase a copy of the program, and install it without agreeing to the EULA, I can still legally run it (MS has been compensated; there's a provision in 17 USC that excludes the running of software from infringement) and MS can, indeed go to hell.

      Of course, I would hope that they don't drag down the entire neighborhood, as I live pretty close by.

      Most copyrighted material is not licensed at all, or as a condition of purchase, software included. Even the legality of a post-sale EULA is the matter of some debate. Don't assume that the things are 100% legit just because software publishers claim that they are. IIRC the case law is almost evenly split, with a slight leaning in favor of the 'EULA's don't count' side.

      --
      -- This and all my posts are in the public domain. I am a lawyer. I am not your lawyer, and this is not legal advice.
  71. No it can't by nagora · · Score: 2
    A click through is not Law. I can not put a clause in a click-through which requires you to give me your first born child or to kill yourself, give up the right to vote etc. Indeed, in the UK at least, click-throughs have all the legal binding of any other un-signed, un-witnessed agreement: none at all. Which is the way it should be.

    TWW

    --
    "Encyclopedia" is to "Wikipedia" what "Library" is to "Some people at a bus stop"
  72. Fraud is a Big Deal by GodSpiral · · Score: 2

    Imposing on the users a gag order on performance issues is a pretty clear indicator that the company's performance claims are fraudulent.

    There should be conusumer protection legislation that prevents such clauses in EULAs.

    btw, Rambus has a similar clause in its licensing contracts.

  73. SQL Server 7 "User Friendliness" by darrint · · Score: 2

    I work with SQL 7. We ran into some severe performance problems when we cranked a lot of transactions at it over ODBC. We found it to be slower than SQL Server 6.5, although some backwards compatibility prevented us from doing a real "apples to apples" comparison.

    Also, our app runs a lot of CPU intensive transactions. SQL Server 7 is self tuning so we provided REAL slow service to our customers for a day or so while SQL 7 figured out what we were doing to it. We knew where the hot spots were, but were powerless to fix the problem because SQL Server 7 is more "user friendly".

    Maybe MS did better with 2000? I don't care to find out. When PostgreSQL in a fault tolerant cluster starts to become more mainstream, I'm going to start looking at moving that direction.

  74. Re:who cares? use SQL 2000 instead by Malcontent · · Score: 3

    What's going to happen when a windows XP comes out? Oh I get it you have to upgrade your database server too.

    --

    War is necrophilia.

  75. An MS Bashing overview of the past few years by On+Lawn · · Score: 2

    I've watched the Slashdot community turn from all Linux to almost pro-Microsoft. I think fuddled attepts at MS bashing have turned into a spin doctoring that is very MS-esque.

    The Kerberos thing, they try to sue people who publish their Kerberos specs, so they link them on Slashdot. Then they try to sue Slashdot. Then, they simply open their specs and we all see there was nothing worry about. (One could suspect them as baiting the community but I won't.)

    Earlier there was MindCraft benchmarks, where NT whooped Linux. Well, as many first started attacking MindCraft for being skewed, they opened their process and showed that infact it was skewed --but not at least in the ways that the community had accused them of! (One could suspect them of baiting the community but I won't.)

    Now we have MS apperantly squelching benchmarks on their SQL servers. Slashdot gets up in a riot, while many people point out that SQL 7.0 was ment for NT 4, and the 2000's were meant for each other.

    Again a nice simple answer that could leave the community red-faced. On close examination however, we consider then what MS is doing in the first place? If MSSQL+ windows 2000 was faster than SQL 7.0 + NT4.0 then there is no to do. Such a benchmark would encourage a double upgrade rather than one! More money right?

    So I take issue with those trying to come to MS's aid on this one. Do they understand what the real issue is? Its not MS's evil ways or kangaroo trial by community. Its simply that they should continue to be open and let their users figure it out for themselves.

  76. Re:SQL Server 7 on W2K? by Anonymous Coward · · Score: 3

    good plan. you can upgrade your OS, but you'll need to upgrade all your other software if you don't want everything to slow down horribly. Would you like the undercoating with that? These OSes will rust up on you in an instant! How about the "protection plan?"

  77. And the point is? by Pinball+Wizard · · Score: 5
    Doesn't Oracle do exactly the same thing? AFAIK, you have to get permission to publish benchmarks. So what. Its in the licence.

    Something is definitely fishy with their hardware if Win2K is twice as slow as NT4. I've run both servers with SQL7 intensively. You couldn't pay me to move back to NT4. 2000 isn't all that much faster, but it is much more stable and its a lot easier to use and administrate.

    Want some real benchmarks? Try here. Notice a pattern? SQL Server is the fastest database server in the world. Not only that, but Win2K is in the top four slots. 2nd place is a DB2 server on Win2K. Here are real, industry standard tests performed by an independent organization, not a company with an agenda to promote or magazines to sell.

    I'm not sure what the point of this article is, other than to stir up more mindless MS-bashing. Well, Timothy, maybe you should try SQL Server or another real database. Pretty much every day around noon we get the same problem because Slashdot can't handle displaying stories while lots of people are posting. A real database would do wonders to fix that.

    --

    No, Thursday's out. How about never - is never good for you?

  78. What the hell? by Codeala · · Score: 2

    The closest artcile I can find is this one, and it compares the throughput of Gigabit Ethernet on NT vs W2K??

    It kind of match Cringely's story:

    • is on Network World (www.nwfusion.com) and titled "Microsoft disputes research about Win 2000"
    • is about NT vs 2000
    • an independent testing lab is involved: Tolly Research
    • is about a NIC
    • and about a week old...

    Further proof that /. will print anything?

    ====

    --

    Codeala - Just another mindless drone
  79. OK, perhaps not click-through, but... by yerricde · · Score: 2

    A click through is not Law... click-throughs have all the legal binding of any other un-signed, un-witnessed agreement: none at all.

    Big-money software licenses (such as Oracle and MSSQL licenses) often require a written contract that has all the consideration and everything, to the effect: "You give up $50,000 and the right to reverse engineer this software and publish benchmarks in exchange for the right to receive this software (we're not giving you the disc until we receive your signature) and use this software in commerce."


    All your hallucinogen are belong to us.
    --
    Will I retire or break 10K?
  80. no db company supports benchmarking by small_dick · · Score: 3

    as i recall, neither MS or Oracle are very enamored with third party benchmarks. the only time they *don't* threaten the publisher is when their product "shines".

    the results are just too easy to skew, and the real-world loading is tough to accurately model.

    i'm trying to learn Oracle on linux -- it's pretty cool the way I can legally install a free OS, then download oracle 8i enterprise for personal use.

    "oratcl" is now on sourceforge, and php3 has gtk+ bindings for standalone applications (but works great through a browser, of course).

    it's a great time to learn about databases...just don't publish those benchmarks!

    --


    Treatment, not tyranny. End the drug war and free our American POWs.
    See my user info for links.
  81. Fair use by blakestah · · Score: 3

    Under standard copyright law, something like benchmarks is considered fair use, and is thus not subject to asinine click through agreements. If something is not covered by copyright law, it cannot reasonably be covered by click through.

    This is also the case in Europe, where, for example, you are legally allowed to resell Microsoft OS licenses. It is the only way to interpret copyright law wrt software that makes sense.

    Oh, silly me. Who expected M$ to make sense ?