June 29, 2011 at 11:18 pm
Hello All,
I found that sp_execute is consuming high resorces in my database.
the commands are as follows:
sp_execute 1
sp_execute 8
sp_execute 6
Can anybody please let me know how can a find what stored procedure is it running?
I have checked the sp_prepare script preceding sp_execute command from SQL Profiler data. But the SQL script captured is incomplete.
From parts of the code I can make out a select statement that it is running a lot of aggregate function and string concatanation.
I have checked the followng link but is not of much help:
http://www.sqlservercentral.com/Forums/Topic701255-65-1.aspx
Can anybody help me to find out what is the query that is being executed and how can I reduce the time taken to execute sp_execute command?
I will have to fix the code that is causing sp_execute ti run so long.
So tips to fix the code is appreciated.
June 30, 2011 at 10:43 pm
Can anybody please help?
July 4, 2011 at 9:30 pm
Hi all,
Can some somebody atleast put in there ideas reagrding this?
July 11, 2011 at 12:16 pm
Can anybody at least share some experience regarding this?
July 11, 2011 at 2:52 pm
.... non answer.
What application is causing this (I have something similar)?
I've had hints to solve this but I never did. Maybe we can have a whack at it together and combine our ressources.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply