November 6, 2019 at 10:06 am
Hi All,
I need to monitor a application (service user) action on SQL server DB e.g when application is querying predefined tables and columns.I do not want to use SQL Server DB audit as audit file size is increasing and getting bigger in size in a day.
Is there a way to get the info that when a user is querying particular table and columns without using SQL serve DB audit functionality . Thanks in advance. any lead is highly appreciated.
Thanks
November 6, 2019 at 10:50 am
A SQL audit needn't be too much of a burden. Set up your filter carefully, limit the file size and the number of files, and import regularly into a database table for easy querying.
John
November 6, 2019 at 7:38 pm
Hi All,
I need to monitor a application (service user) action on SQL server DB e.g when application is querying predefined tables and columns.I do not want to user SQL Server DB audit as log file size is increasing and getting bigger in size in a day.
Which log file, the database's log file, or the SQL DB Audit file?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
November 7, 2019 at 7:37 am
SQL DB Audit file is increasing in size.
November 7, 2019 at 7:38 am
Thanks John for you feedback. If i do not get any other solution i will go with SQL server audit.
November 7, 2019 at 2:11 pm
If the audit file is increasing in size, why is this a problem?
Regardless of what method you choose to perform audits, you will need to allocate space for it. You will also likely need to set up a purge of the audit files. For example, you may only want to keep 30 days worth of files.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply