Re: SQL Server 2005 - Server side trace script
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Andrew J. Kelly (sqlmvpnooospam@xxxxxxxxxxxx) writes:
I will ask again. Did you ensure that the TextData column is checked off
as one of the columns in Profiler in the first place? You can add or
remove any columns or events that you want and TextData is not one of
the selected columns by default for an RPC event.
Actually, I seem to recall having made the same observation as Anand.
If I have a server-side trace, and open it in Profiler, TextData is
missing for some RPC events, although it's returned by fn_trace_gettable.
It was a while since I ran into this, but it may be that if I include
BinaryData in the trace, this does not happen.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
Relevant Pages
- Re: Very slow query
... with lots if information in Books Online, Books, Courses, the Net etc. ... While testing the query in QA, use the "Show Estimated Query Plan" feature. ... This is what I suggest you also pick up using Profiler. ... Tibor Karaszi, SQL Server MVP ...
(microsoft.public.sqlserver.programming) - Re: SQL Profiler 2005
... that tracing from Profiler. ... definitely not lean on the server. ... The way to get a kickstart on server-side trace, is to set up the trace ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(microsoft.public.sqlserver.tools) - Re: Activity Monitoring for a Single Table
... A server-side trace as Aaron suggested gives you the offending statement ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools) - Re: Audit stored procedures
... Rather than using Profiler, use a server-side trace instead. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.security) - Re: SQL Server 2000 Audit for login
... > significant overhead on the database. ... However, it's better to use a server-side trace and trace to a file, and ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver) |
|
