Is there is any method or free tool (apart from SQL Profiler) available by which I can get what all stored procedures/queries are executed by an application when it is running. I dont have the source code of the application as it is a third party application.
What you see using Profiler is what you will see with other software. Anyway, with Spotlight from Quest you can see what SP and Queries are in cache. With Diagnostic Manager, from Idera, you can get sp and queries not in cache but the longest ones. Nothing new, respect to Profiler. Luis Martin Moderator SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte All postings are provided “AS IS†with no warranties for accuracy.
I've moved to relevant forum. Luis Martin Moderator SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte All postings are provided “AS IS†with no warranties for accuracy.
