Đang Thực Hiện

TSQL Connection History

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.

Kỹ năng: SQL

Xem thêm: sql connection history, tsql connection history, problem statements, TSQL, sql audit history, app session, sql stored function, post execute, session app running, production app, app analysis, tsql history sql statements, connection client, audit sql, sort problem, audit application, express 2008, performance problem, impossible app, sql connection, sql server connection, client sql server, sql analysis, jeremybentvelzen, server audit

Về Bên Thuê:
( 3 nhận xét ) Castle Hill, Australia

Mã Dự Án: #1732667

Đã trao cho:

sikandermandal

Please see PMB.

$50 AUD trong 1 ngày
(9 Đánh Giá)
4.6

2 freelancer đang chào giá trung bình $75 cho công việc này

digidreamstech

Hi,I am ram from digital dreams technology. I have worked on complex queries and PL/SQL on SQL Server. Please check message box for more details.

$100 AUD trong 2 ngày
(3 Đánh Giá)
3.9