Reading .trc files on SQL Server 2000/2005

Hi,
We have a requirement to read the .trc files generated by SQL server
in real-time or atleast near real-time. We do not want to interfere
with existing SQL server setup by running functions like
fn_trace_get_table. The requirement is to get the events logged in .trc
files by directly reading them. SQL Profiler can read the trace files,
but looks like the .trc file format is not published by Microsoft. But
I also see some tools like Idera's SQL Compliance Manager are capable
of directly reading the trace files. Can any one suggest an approach to
read trace file without having to disturb the existing SQL server
setup.
Thanks
ad kompellaSQLBenchmarkPro is a tool I designed to organise trace scheduling,
collection & analysis accross multiple server concurrently - for both SQL
2000 and SQL 2005. www.gajsoftware.com
Regards,
Greg Linwood
SQL Server MVP
"adkompella" <adkompella@.gmail.com> wrote in message
news:1156924170.713163.303500@.h48g2000cwc.googlegroups.com...
> Hi,
> We have a requirement to read the .trc files generated by SQL server
> in real-time or atleast near real-time. We do not want to interfere
> with existing SQL server setup by running functions like
> fn_trace_get_table. The requirement is to get the events logged in .trc
> files by directly reading them. SQL Profiler can read the trace files,
> but looks like the .trc file format is not published by Microsoft. But
> I also see some tools like Idera's SQL Compliance Manager are capable
> of directly reading the trace files. Can any one suggest an approach to
> read trace file without having to disturb the existing SQL server
> setup.
> Thanks
> ad kompella
>|||On 30 Aug 2006 00:49:30 -0700, "adkompella" <adkompella@.gmail.com>
wrote:
> We have a requirement to read the .trc files generated by SQL server
>in real-time or atleast near real-time. We do not want to interfere
>with existing SQL server setup by running functions like
>fn_trace_get_table. The requirement is to get the events logged in .trc
>files by directly reading them. SQL Profiler can read the trace files,
>but looks like the .trc file format is not published by Microsoft. But
>I also see some tools like Idera's SQL Compliance Manager are capable
>of directly reading the trace files. Can any one suggest an approach to
>read trace file without having to disturb the existing SQL server
>setup.
If you're in a serious hurry, I believe you can write your own
listener using debug API hooks.
J.|||Thanks for the reply. But I have no idea about the debug API hooks, can
you give me any pointers to the debug API hooks for this particular
requirements?
kompella
JXStern wrote:
> >
> If you're in a serious hurry, I believe you can write your own
> listener using debug API hooks.
> J.|||On 30 Aug 2006 21:45:31 -0700, "adkompella" <adkompella@.gmail.com>
wrote:
>Thanks for the reply. But I have no idea about the debug API hooks, can
>you give me any pointers to the debug API hooks for this particular
>requirements?
>kompella
>JXStern wrote:
>> >
>> If you're in a serious hurry, I believe you can write your own
>> listener using debug API hooks.
I'm not current on this, but if you search the online doc and post to
the windows API newsgroups, should be able to figure it out.
Sorry not to have it at hand.
J.