I'm a bit of newbie when it comes to analysing a slow query, using a trace. Effectively, a user has reported that when saving a invoice from within a application, it takes far too long to do so. We've ensured that when they are saving the form, no one else is connected to the DB (UAT Environment) but we still experience the problem.
We've ran a trace to see if a bottleneck can be highlighted, having reviewed the results I cannot see anything hanging (taking the start and end time of each query into consideration).
I have though noticed that the application uses sp_prepexec to query the database, does anyone know of any issues relating to this?
Should I be looking at other things from within the trace?