Insert Performance problem on Win Server 2003 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Insert Performance problem on Win Server 2003


I have just migrated (restore) sql server from an XP machine to a win server 2003 machine. All the hardware on the win server 2003 machine is much better than the one on the XP.
When I tested I got weired results. The insert was 7 times slower!!! on the win server 2003 machine. Even more weired was the fact the a select statement I ran was much faster on the win server 2003 than the XP (the other way round here…. 20 times faster).
I use ADO.NET from a C# code and tried inserts with batch statement, stored procedure, bulk insert and using a disconnected adapter, all showing the same result – the inserts are much slower.
Another thing – no network issues as i ran it from different machine and even when the machine i ran it from (meaning the client side) was the win server 2003 machine i still got the same result (around 5.5 slower than the XP).
What do you say of that? I was expecting a better performance of inserts in the win server 2003 and got 7 times slower…
Thanks,
Dror
Kindly don’t duplicate post. Luis Martin
Moderator
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
Referhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9178 for further update. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>