SQL Server Performance Forum – Threads Archive
Windows server 2003 and SQL 2000Does 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
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 _________
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
True, rather than upgrading the OS try to install on fresh Win2K3 machine. Check this link http://www.microsoft.com/windowsserver2003/evaluation/performance/tpcc2.mspx about the performance and also this tips link http://www.sql-server-performance.com/operating_system_tuning_w2003.asp for information. _________
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
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
Think targeted resets. John Fullbright