SQL performance on Windows 2000 vs 2003

Question

SQL performance on Windows 2000 vs 2003

William Hall Dillon-327038

SSC Eights!

Points: 990
More actions
February 6, 2007 at 2:37 pm

#118919

Hi All:
I've heard that SQL 2000 performance is better on Windows 2003 vs 2000. Has anyone else heard of anything like this?
Thanks
William

Viewing 5 posts - 1 through 4 (of 4 total)

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

Ben Mildren-398690 SSC Journeyman Points: 83 More actions · Answer 1

might be with regards to hyperthreading.. ..windows 2003 works better with hyperthreading than 2000.. ..but then again it's a debate whether you turn hyperthreading on for sql anyway..

William Hall Dillon-327038 SSC Eights! Points: 990 More actions · Answer 2

Ben

Why is it a debate to turn on hyperthreading?

Thanks

William

Summer90 SSC-Dedicated Points: 32891 More actions · Answer 3

Quite honestly from a performance standpoint I see no great difference in the operating systems. Although, I have never done a same hardware/install on one vs. the other. At this point, if the choice is yours, go with Win2k3. It is more up to date and does offer some stability issues.

William Hall Dillon-327038 SSC Eights! Points: 990 More actions · Answer 4

For whatever it's worth, I ran across this article. Highly recommending 2003 over 2000

http://www.sql-server-performance.com/operating_system_tuning_w2003.asp

William