I was running SQL server 2000 on Windows XP professional.
Recently I installed SQL Server EE 2000 (SP3a) on a new machine (Windows 2003 standard version).
And I transferred my old database and program to new DB on Windows 2003.
The new server has higher computing power (Dual XEON - 2.8GHz, 2GB Memory) than old one (Single XEON - 2.8GHz, 1GB Memory).
Howerver, the newer DB machine gives very poor performance compared to old one, though it has higher computing power and larger memory.
(My program tries 1000 insertions into a certain table. The old DB machine returns result almost as soon as I fed the query. But the new DB machine was nealy locked and gives result after 7 seconds.)
Database, index, and etc. were created with same script.
What would be cause of this slow down?