SQL Server Performance Forum – Threads Archive
Insert into :Performance issue
Hi, I have a insert into statement in sp1 which executes sp2.sp2 retuns around 2000 rows after lot of processing.When I execute sp2 directly from query analyser it takes about 2-3 mins but if I do theinsert into tab1
exec sp2 It takes 20 mins. what are my other options, how can i improve the performance? Thanks,
ssm
Dear Friend Posting the code of SP1 and SP2 will be of lot help in analyzing the situation Anil Never Give Up
Also check the execution plan for the referred stored procedures, by clearing the cache for optimum execution. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
]]>