extended event - VIEW usage

  • Is there a way to see which of my "user" VIEWs are being accessed by users? ...or a list of the VIEWs not being used.

    I am not talking about system/DMV views.

    thanks,
    Kevin

  • sextonk - Thursday, April 6, 2017 3:33 PM

    Is there a way to see which of my "user" VIEWs are being accessed by users? ...or a list of the VIEWs not being used.

    I am not talking about system/DMV views.

    thanks,
    Kevin

    In profiler, the event would be Audit database object access event class. Could be there but I'm not seeing the equivalent for extended events on 2012.

    Sue

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply