Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Optimize Transact SQL?
Message
De
09/04/2008 21:34:24
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Optimize Transact SQL?
Divers
Thread ID:
01309550
Message ID:
01309550
Vues:
50
I'm trying to trouble shoot why my customers accounting system is so slow performing certain functions. In reviewing the following statement in the profiler the duration is 271. The majority of all the other like statements have a duration of 2. What's the best way for me to figure out what is slowing this down so much?


exec sp_executesql N'INSERT INTO PROTEMP..t07422661_94
(DEPTID,DEPTDES,SEGVAL,ADDUSER,ADDDATE,ADDTIME,LCKSTAT,LCKUSER,LCKDATE,LCKTIME,TOGGLE) VALUES
(@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11)',N'@P1 char(6),@P2 char(35),@P3 char(20),@P4 char(4),@P5 datetime,@P6 char(8),@P7
char(1),@P8 char(4),@P9 datetime,@P10 char(8),@P11 char(1)','023705','#237 Drivers ','00237 ','MJ
','1998-05-09 00:00:00:000','10:00:17',' ','LC ','2000-03-03 00:00:00:000','11:20:58','X'

Thanks In Advance
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform