That is a nice card but it depends on what type of PSU you have and how many watts it is. That card requires a 400w PSU. But your PSU if it is smaller it still might work, just have to see what is on the 12v rail
How many amps on the 12v rail that is all I need to know. All the info is on a sticker on your PSU you just have to look for the numbers 3.3v = 14a + 5.0v =17a + 12v =16a.
I need the 12v one sometimes there are more than one 12v rails (12v1 and 12v2) Also here is some more AGP type cards. Let me know and I hope this helps a little.
Looking on newegg's site I was surprised to find so many AGP cards, and almost all of them are open box/return products lol. Ya, I think that is about the only GPU on there that I would purchase considering your PSU should take it. Should be a huge step up from the 9800Pro moving from 128MB to 1GB of ram (10x increase!)
A newer system drive (use acronis to move your system to the new drive) would breathe some new life into things as well, but then again I guess HDDs are still a little expensive these days. You need ATA100/133, so a new one like this: http://www.newegg.com/Product/Product.aspx?Item=N82E168...
Or else an old referbished one like this: http://www.newegg.com/Product/Product.aspx?Item=N82E168...
The newer one would be faster, but the older one would be faster than your current drive, and a lot cheaper... always hesitant about refurbished HDDs, but with PATA it is hard to pick anything else. Also, getting to the HDD in those Sony machines can be a bit tricky if memory serves right.