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

Question

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

jellybean

SSCrazy

Points: 2004
More actions
May 16, 2018 at 6:34 am

#410497

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.

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

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

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 1

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)

jellybean SSCrazy Points: 2004 More actions · Answer 2

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.

Irish Hall of Fame Points: 3958 More actions · Answer 3

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

jellybean SSCrazy Points: 2004 More actions · Answer 4

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.. 🙁

Sue_H SSC Guru Points: 90860 More actions · Answer 5

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

jellybean SSCrazy Points: 2004 More actions · Answer 6

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.