Posted by Erland Sommarskog on 10/01/03 11:25

MAG (mohamed.gad@gmail.com) writes:
> I have a problem regarding SQL Server 2000 SP3,
> I have SP that calls other SP and it inserts about 30,000 records as a
> time,
> in the development environment (MS Windows 2003 Enterprise, 256 RAM,
> 3.0 GHz Intel Processor) takes about 6 seconds to run this SP.
>
> But, with the same Software but, 2.6 GHz Intel and 1 GB Ram, it runs
> very slow it takes more than 135 Seconds to run,

Are the tables the same size on both machines?

What does DBCC SHOWCONTIG say for the tables on the two machines? That is,
one could have severe fragmentation.

Are indexes the same?

And - most of all - are there any triggers on the tables in either server?

Also, I noted from your other post that you are using IDENT_CURRENT. Note
that this function is not safe for concurrent use. (Yeah, I noticed that
did not have concurrent access to your database, but nevertheless.)



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]