I need a stored proceedure which I can execute from my VB.NET Client Server Application which will get the current Session ID and give me the last 5 Minutes of TSQL Statements which have been run.
SQL Profiler can perform this in a Post analysis function however this is to problem solve a app issue while in production which makes it impossible to start the profiler at the approriate time.
The SQL Server is also SQL Server Express 2008.
I would prefer to not have to switch this on and off however I'm not sure if it is possible to achieve without constantly running some sort of audit which will impact performance.
Note: I am not interested in simply returning the current running SQL, but in the SQL which ran a couple of minutes ago.