Tag Info

New answers tagged

2

I had the same issue. I ran an SQL trace on a remote server and transferred the trace files to a local directory on my workstation so that I load the data into a table on my local SQL Server instance for running queries against. SELECT * INTO ProfileTracesTable FROM ::fn_trace_gettable('C:\Users\anthony\Documents\SQL_traces\first.trc', default) However, ...


2

The Degree of Parallelism event actually records the query parallelism in the BinaryData column, not the EventSubClass. See here: 0x00000000, indicates a serial plan running in serial. 0x01000000, indicates a parallel plan running in serial. >= 0x02000000 indicates a parallel plan running in parallel. From my simple tests, RML or trace replay do not ...


0

I can't test it because I don't have Express installed here, but can't you use Profiler on SSMS 2012 on an express edition? SSMS 2012 is available to download here free, I can't think of any reason why anyone using SQL Server shouldn't be using it. Can someone with an Express Edition installed verify?


0

If looking for a UI that will get traces in real-time, the ExpressProfiler is good. But it's a bit simple, and not very configurable. This is a nice alternative, very configurable and I use use it all the time now. It's called Sql ExpressTRace and this link is to an article that lets you download the compiled UI and the code too: ...


0

What you ate setting there is a parametrised insert or more generically use of a "prepared statement" (you will see select statements and others like this too). You might see more specific detail in the "execute prepared SQL" trace option. If you can't see what you need anywhere in what the profiler can show you, you could try adding a "for insert" trigger ...



Top 50 recent answers are included