SQL server 2014 profiler bottom pane not displaying trace -- please help...

  • Hi,

        I hipe I'm posting in the correct forum. Apologies if I'm not...I using MS Sql Server 2014 Profiler (v.12.0.2000.8) on a Window 10 Enterprise computer (64 bit system). I can successfully trace the database in the
    upper pane of the profiler. It logs nicely. However, when I click on the row - it does not appear in the lower pane of the profiler (which it did before the upgrade)
    and hence I cannot copy and paste the command out quickly.

        I'm just wondering has anyone come accross this and is there any way to enable it? It's a very useful feature...

        Any help much appreciated! Thanking you...
    J.

  • jellybean - Wednesday, May 16, 2018 6:34 AM

    Hi,

        I hipe I'm posting in the correct forum. Apologies if I'm not...I using MS Sql Server 2014 Profiler (v.12.0.2000.8) on a Window 10 Enterprise computer (64 bit system). I can successfully trace the database in the
    upper pane of the profiler. It logs nicely. However, when I click on the row - it does not appear in the lower pane of the profiler (which it did before the upgrade)
    and hence I cannot copy and paste the command out quickly.

        I'm just wondering has anyone come accross this and is there any way to enable it? It's a very useful feature...

        Any help much appreciated! Thanking you...
    J.

    Does your trace include the "text" column?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Hi Jeff, yes the "TextData" column is displaying. I have played with it's location relative to the other ie first, second last position but when I click on the rtow - the bottom panel still does not display the contents. 
    Any ideas? I'm at my wit's end....
    J.

  • I feel like I need to change my handle to "yet another Jeff." 😀

    jellybean, what options are you selecting in your Trace? I generally use a blank template and then select a few items:

    Stored Procedures: SP StmtCompleted
    TSQL: SQL StmtCompleted

    I then will filter based on query duration and then the Database I'm watching. If I want to capture more statements in a shorter period of time, I'll remove the duration filter.

    Typcially this gets me the most information in the shortest time possible. Should I need to add more options to capture parameters or something else, I will add those in. But this is where I typically start off.

    I hope this helps in some way.

    Regards, Irish 

  • Hi Jeff (no, the other one)
        Thanks for the suggestions. I tried a few different templates and a few other variations and while handy, I still cannot get the command to display in the bottom panel. Has anyone else come across this? Surely - I can't be the only one.. 🙁

  • jellybean - Thursday, May 17, 2018 9:14 AM

    Hi Jeff (no, the other one)
        Thanks for the suggestions. I tried a few different templates and a few other variations and while handy, I still cannot get the command to display in the bottom panel. Has anyone else come across this? Surely - I can't be the only one.. 🙁

    Try adding the BinaryData column and see if that makes a difference. There was or is an issue related to that with some events and Profiler.

    Sue

  • Hi Sue,
       
       Thanks for the suggestion. I t was already added but I tried again and moved it around etc for blank and standard templates and tested a few variations bit still it's not appearing in the bottom pane.
    Confused,
    J.

Viewing 7 posts - 1 through 6 (of 6 total)

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