Re: Why the performace differs?

MAG (mohamed.gad@xxxxxxxxx) 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@xxxxxxxxxxxxx

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

.

Relevant Pages

  • Re: Migrate SharePoint Portal 2003 and it DB Server to another ser
    ... I first applied WSS sp3, then rebooted then applied ... I have not rebooted my SQL server. ... Which order did you do the two SP3 installations? ... I am backing and restoring using the SharePoint backup and restore utility. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Neuinstallation
    ... Längerfristig solltest Du auch die anderen Rechner auf SP4 bringen. ... > Nach der Neuinstallation liess sich der Enterprise Manager nicht mehr ... SQL Server Verzeichnis existiereren. ... > Mit dem Aufspielen von SP2 und SP3 geht dieser Fehler auch nicht weg. ...
    (microsoft.public.de.sqlserver)
  • Re: SP4 performance Woes.
    ... Otherwise you can also enable trace flag 9059 to revert to the SP3 behaviour ... "Trace flag to revert to the behavior in SQL Server 2000 SP3") ... besides avoiding SP4 like a virus. ...
    (microsoft.public.sqlserver.setup)
  • Re: MSXML6 Service Pack 2 (KB954459) package is not supported on the current processor type
    ... Christoph Muthmann schrieb: ... XP SP3) erhalte ich folgende Meldung: ... SQL Server 2005 Arbeitsstationskomponenten zu installieren, ... (denn geprüft wird vermutlich nur eine Versionsnummer) ...
    (microsoft.public.de.sqlserver)
  • Re: SQL SP 3 and Slammer Virus
    ... SP3 contains all the previous fixes. ... > necessity to install MS02-039 patch right? ... >>Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)