May 16, 2005 at 6:52 am
A new IIS web app has been put into production which is timing out with 30/40 users. It's database is hosted on a separate dual processor 64bit Itanium SQL2000 server (W2003) with 8Gb RAM and SAN storage. This server has been shown to run blindingly fast for other databases hosted by it.
We've found that the new app is poorly written and fires off hundreds of small queries for every web page load. The SQL server CPU runs at 100% for sustained periods of time.
Strange thing is that when hosting the database on a lower specced 32bit dual processor SQL server the application performance doubles. Disabling a processor and running it on a single processor gives a further improvement...
We've tested using a separate 64bit Itanium server with the same poor results. Installing SQL servicepack 4 made things even a little slower.
What could be causing this slowdown?
May 19, 2005 at 9:27 am
Hi Rob, I don't know but would be incredibly interesting in hearing what you discover (we have itanium2's here too so i'm always interested in anything about them, especially related to performance).
From the sounds of it the smaller single processor server is able to complete the queries without bothering to check it it can do anything in parallel, if it were me i'd be looking at turning parralellism off on the itanium and seeing what effect that has.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply