Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Optimize Transact SQL?
Message
From
09/04/2008 21:34:24
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Optimize Transact SQL?
Miscellaneous
Thread ID:
01309550
Message ID:
01309550
Views:
49
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
Next
Reply
Map
View

Click here to load this message in the networking platform