June 15, 2006 at 7:43 am
I have a trace running on some of our users. I'm tracking RPC:Completed and SQL:BatchCompleted filtered by user. The problem im running into is that the TextData column isnt returning the name of the stored procedure being called. All I see is exec sp_Execute 1, 1231, 1231231.
I assume the numbers following the sp_Excecute are parameters sent to the procedure. What I need to know is which procedure is being called. BTW - the application that's generating the activity is an MS Access app.
June 15, 2006 at 11:00 am
That means there is a prepared SQL statement. Look for an sp_prepare statement prior to that. Worst case scenario, add the showplan events (make sure you get the right columns) and you'll see the execution plans, which will give you an idea of what's going on. We've had to do that in some of our applications.
The following article is a bit dated, but it'll give you an idea of what's going on with that (see section 5):
6 Ways to Boost ADO Application Performance
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply