SQL Server Profiler bottom pane

fnvucqvd 于 2023-03-17 发布在 SQL Server

关注(0)|答案(1)|浏览(114)

I'm currently using SQL Server 2012, but I've noticed this behavior back several versions.

Say you run a SQL Server Profiler session. You then select a bunch of lines in the profiler, they get displayed in the bottom pane, I'm not sure what it's called, but it has the T-sql that's actually run by profiler in there.

However, if you look closely it truncates the queries. From copying and pasting, it appears that it can only hold 16k of data. Does anyone know of a way to increase this size, or any documentation of exactly what the limit is?

-Eric

sql-server

来源：https://stackoverflow.com/questions/18728490/sql-server-profiler-bottom-pane

1条答案

按热度按时间

l5tcr1uw1#

I'd forgotten all about this thread. What I do now with SQL Server Profiler 18 is do a File > Export > Extract Sql Server Events. I then open the saved SQL Script in SSMS. I have also tried server side tracing, but I do still occasionally run into problems with huge LINQ queries where they still get truncated. See SQL Server Profiler text data gets truncated

赞(0）回复(0）举报 2023-03-17

我来回答

SQL Server Profiler bottom pane

1条答案

相关问题

热门标签

最新问答