|Subject:||Slow Insert in SQL Server|
|Posted by:||Volks (patrick.sima…@isac-inc.com)|
|Date:||16 Aug 2006|
It takes 4 minutes to insert 40 000 records on a SQL Server and 40 sec
on an other SQL Server. The slower run on windows 2000 terminal server
and the faster on windows 2000. The slower The slower have 2 Go of
ram, the faster 512 Mo!!!
How to diagnostic what's going wrong on the slower server? I can't
change the application who do the insertions.