Add support for Sql Server trace files


Author
Message
Email User
Email User
Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)
Group: Forum Members
Posts: 36, Visits: 106

I would like to see support for SQL Server trace files (*.trc) in LogViewPlus.  Is this something you plan to add in the future?


LogViewPlus Support
LogViewPlus Support
Supreme Being (5.3K reputation)Supreme Being (5.3K reputation)Supreme Being (5.3K reputation)Supreme Being (5.3K reputation)Supreme Being (5.3K reputation)Supreme Being (5.3K reputation)Supreme Being (5.3K reputation)Supreme Being (5.3K reputation)Supreme Being (5.3K reputation)
Group: Moderators
Posts: 1.1K, Visits: 3.7K
We spent some time looking into this possibility.  The problem is that reading SQL Server trace files requires libraries (SMO) which need to be in sync with the SQL Server version responsible for writing the files.  Some of these libraries need to be installed on the machine and cannot easily be distributed by a 3rd party.  It is probably possible to reverse engineer the format - but this is not something we are considering at this time.

In this case, we suggest you roll your own Custom Reader which is specific to your SQL Server installation.  For more information, please see: https://www.logviewplus.com/docs/custom_readers.html

Thanks for the suggestion,

Toby
Edited 4 Years Ago by LogViewPlus Support
Email User
Email User
Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)Gaining Respect (189 reputation)
Group: Forum Members
Posts: 36, Visits: 106

As a work around, I can open the SQL trace in SQL profiler then File -> Save As -> Save to Database Table.

Once I have the data in a table, I can either export the results to a CSV file or access the table directly from LogViewPlus.


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Login

Explore
Messages
Mentions
Search