Re: Reading .trc files of SQL Server 2000/2005
- From: "Greg Linwood" <g_linwood@xxxxxxxxxxx>
- Date: Thu, 31 Aug 2006 00:29:58 +1000
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
"adkompella" <adkompella@xxxxxxxxx> wrote in message
news:1156924449.223545.22150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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
.
- References:
- Reading .trc files of SQL Server 2000/2005
- From: adkompella
- Reading .trc files of SQL Server 2000/2005
- Prev by Date: Name change, can't find origin of error
- Next by Date: DeadLock @ page+key (mix) level how to solve
- Previous by thread: Reading .trc files of SQL Server 2000/2005
- Next by thread: Name change, can't find origin of error
- Index(es):
Relevant Pages
|
Loading
