Slow Insert in SQL Server

Giganews Newsgroups
Subject: Slow Insert in SQL Server
Posted by:  Volks (patrick.sima…@isac-inc.com)
Date: 16 Aug 2006

Hi,

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.

Replies