Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
homam
Starting Member
31 Posts |
 Posted - 2006-04-12 : 20:02:15
|
| I have a program written in .NET 2.0 that imports a text file with some elaborate rules. It basically calls a stored procedure in the database to process each row sent from the app.I found out that importing into SQL Server 2005 by calling this stored procedure is much faster on a Windows XP machine running SQL Server 2005 Standard than on Windows Server 2000/2003 machines running SQL Server 2005 Standard. There is no other load on these machines, so locking isn't a problem here. It's just that performance is somehow bottle-necked on the server OS machines.Now this is completely counter-intuitive. The server machines have better hardware and the server OS is supposed to be better performing and more scalable.I ran sp_configure with 'show advanced option' and compared the settings and I can't find something that could cause such perf degradation on the Server OS.Has anybody encountered such issue? Are there any know fixes/configuration/upgrades that might speed insertion speed on Windows Server versions? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-04-12 : 20:47:45
|
Have you updated all your statistics on both servers? Have you done your tests from a cold restart (or flushed the data and procedure caches)? Even the slightest difference in these situations can significantly impact performance. Caching is the first thing to suspect, especially if you ran the code on the XP machine a few times. Are you sure the server isn't running something else (antivirus, perf counters?) My experience has been that even identical hardware with identical databases under identical conditions still don't perform identically. Gremlins, sunspots, dust, etc., SOMETHING causes some discrepancy.  P.S. - See if your server's disk controller is caching writes, and disable it. Look at all the differences in the disk hardware and settings too, one of them might be the culprit. |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-04-12 : 21:48:52
|
| do you have hyperthreading turned on on your server? -ec |
|
|
|
|
|
|
SQL Server on WinXP faster than Win server OS?