Reading .trc files of SQL Server 2000/2005

30 Aug 2006 7:54 AM

adkompella

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

30 Aug 2006 2:29 PM

Greg Linwood

SQLBenchmarkPro 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

Show quote

"adkompella" <adkompe***@gmail.com> wrote in message
news:1156924449.223545.22150@m73g2000cwd.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
>