SQL Server Performance

Windows server 2003 and SQL 2000

Discussion in 'Performance Tuning for Hardware Configurations' started by BigJimSlade, Aug 9, 2003.

  1. BigJimSlade New Member

    Does anyone have any experience or metrics on SQL server 2000
    running on windows server 2003?

    I have seen claims of increased file system performance and better memory usage/management

    I'm trying to determine if upgrading the OS will improve performance and by how much in order to get some ROI numbers.

    pointers to any MS articles would be great

    Thanks
  2. satya Moderator

    Refer to http://www.microsoft.com/sql which is the base for the information required.
    I've few metrice and aticles referenced (at office), could be able to post once back on Monday.

    HTH

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
  3. joechang New Member

    i am using 2003, but have not noticed any difference in the basic SQL operations.
    i would not hestitate to recommend 2003 for new installations, but upgrading sql server from w2k to 2003 is another matter,
    i also have no doubt that MS has substantially improved web server performance for .NET apps, as reported in the Nile benchmarks
  4. satya Moderator

  5. BigJimSlade New Member

    After posting I found some of the TPC articles.

    it will take some time to wade through that muck to find the actual truth.

    I was hoping to see if the I/O functions in windows 2003 have improved.
    It looks like they have but; as SQL Server handles I/O differently than normal apps I'm not sure as to how much of a benefit it will have.

    Thanks for the info
  6. joechang New Member

    win 2003 replaced the SCSIport driver with a STORport driver,
    the SCSIport driver has all the generic SCSI capabilities so that a SCSI adapter vendor only has to do a mini-port driver for the specific details of their own adapter.
    However, SCSIport did not have sufficient features to make full use of the capabilities of Fibre Channel, so either the vendor had to make do with the limitations or write their own port driver. STORport is supposed to fully comprehend FC
  7. fullbrij New Member

    Think targeted resets.

    John Fullbright
    MOSMWNMTK

Share This Page