I was quite happy with XP myself. However, Microsoft wanted to shut down XP when Vista was released. Unfortunately for them, Vista was a piece of crap and businesses shunned it. Windows 7 is supposed to have corrected the problems businesses had with Vista, and if that's the case, XP support will be shut down.
Moving from 32-bit to 64-bit is a biggie for me. My old box had 4 GB of RAM, but any 32-bit operating system will only use 3 GB. The addresses for the rest is beyond the capability of 32-bit I believe. My new box has 8 GB of RAM which is now fully used with the 64-bit OS.
I've been running TS2 all all morning without any problems. In fact I was having so much fun doing so, I forgot to add my tweaks to the Program Files.
to be exact windows xp 32 bit or windows vista 32 bit will only see 3.25 GB of ram regardless on how much you have.
for example you have 10 gb of ram on a machine that has windows xp 32 bit, windows xp will only see 3.25 of your 10 gb of ram.
on the other hand, windows xp 64 bit and windows vista/windows 7 64 bit will see all 10 gb out of 10 gb of ram.
just because the operating system only sees 3.25 gb of ram doesn't mean it will only use 3.25 gb of ram. it will use all 10 gb of ram but it will only see 3.25 gb of it.