2

I'm trying to monitor when Views are being called in SQL Server.

Using Extended Events, I've created a Session and included event "sql_statement_completed".

Then I've added 1x filters on this:

sqlserver.database_name | equal_i_sql_unicode_string | MyDatabaseNameHere

So the session logs all sql statements across that particular database.

However, I'd like to only monitor when Views are being called. Ideally, something to track against ObjectType = 8278.

Is this possible?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.