All,
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,
I have read a lot of articles about expanding the SQL Memory and give
it a higher process privilege but, with no use,
I don't know where the problem is, do you have any idea about what is
the problem?
Thank you in advance,
MAG