April 20, 2009 at 3:34 pm
Hi
I have recently run a routine to highlight which prcedures on our sql server machine has the most impact on the server (http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/ - Thanks to Gail Shaw for a great article ;-)) and found that the procedure that came out on top was something called 'sp_executesql'
I wondered if anyone could throw any light as to what this procedure is and why it takes up so much resource?
Cheers
Matt
April 20, 2009 at 4:37 pm
That procedure, by itself - is not the problem. That procedure executes a sql command that is dynamically built.
You can look in books online to get more information on that procedure.
You need to look at the textdata and see exactly what is being called by sp_executesql.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply