April 19, 2017 at 6:33 pm
Hi,
I need to capture all T-SQL commands run by a specific App login on a specific database as the connections from the App login suddenly spike from 20 to 600 at specific times and the App team needs to find out what SQLs are being run.
I found a trigger and table solution online but it didn't write anything. I did not try Database Audit as yet.
Jay
April 19, 2017 at 7:55 pm
What version of SQL Server?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 19, 2017 at 8:44 pm
SQLRNNR - Wednesday, April 19, 2017 7:55 PMWhat version of SQL Server?
SQL Server 2014 Ent Ed.
April 20, 2017 at 9:28 am
I would create an extended event session to trap all sql statements for that login and even narrow it down to the specific database.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 20, 2017 at 9:48 am
SQLRNNR - Thursday, April 20, 2017 9:28 AMI would create an extended event session to trap all sql statements for that login and even narrow it down to the specific database.
+1. Use XE
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply