• BrainDonor - Friday, October 13, 2017 12:56 AM

    Thom A - Thursday, October 12, 2017 6:24 AM

    That's a handy little node Microsoft have added to SSMS (17.3). They've put "XE profiler" at the bottom of the objects for a serve. Effectively does the job of profiler via Extended Events (but, obviously isn't using profiler). A nice little feature, and much easier to use than having to create an Extended Events for something you don't already have set up (and don't need long term so remove afterwards).

    It is nice but there are a few bugs, which is a pity because I don't believe it was a major technical challenge to add it.

    Mmm, after a bit more investigation, noticed that there is no option to filter on Username, only nt_username. As we have SQL Authentication enabled, not that helpful... D'oh!

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk