| Greg Linwood 2005-11-29, 1:23 pm |
| You're on the right track with reading log files - Lumigent is the best tool
for this (they've been around for years). You can also use fn_dblog()
though, eg: SELECT * FROM ::fn_dblog(null, null)
Performing trace / profiling is a bugger with SQL 2000 in many ways. Hence,
I've designed a tool called SQLBenchmarkPro which makes this MUCH easier.
We've got a nice beta available for free right now which you're welcome to
pull down & try out from: http://www.gajsoftware.com
HTH
Regards,
Greg Linwood
SQL Server MVP
" MSSQLServerDeveloper
" < MSSQLServerDeveloper
@discussions.microsoft.com>
wrote in message news:9E1B5217-D450-491E-83E5- D19BE190E9F8@microso
ft.com...
> Is there any information out there on how to read the SQL Server 2k log
> files. The following are two things I dont want to do - 1. use a third
> party
> tool (ie; Lumigent Log Explorer) and 2. Turn on trace/profiling. I just
> want
> to read the log files - somebody must know how to do it if there are 3rd
> party tools...
|