Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lmoran
Starting Member
1 Post |
 Posted - 2007-02-28 : 10:30:01
|
| Hi, does someone know a good tool to analyze log ?In particular, it would be good to have one that works over the database log file, not requiring special software installation (like Lumigent's).Is there a tool coming directly from Microsoft ?ThanksLuis |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-28 : 12:02:42
|
| You must use a third party tool such as Lumigent's Log Explorer. Red Gate has a similar tool. I believe their prices are similar.Tara Kizer |
 |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-02-28 : 15:33:00
|
| What is it you want to do with the log. Are you looking at Transaction logs or SQL Server Activity logs?For Transaction Logs you can use DBCC Log(DBname, 3) to get a good idea what is going on.Raymond LaubertMCDBA, MCITP:Administration, MCT |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-28 : 15:44:17
|
quote:
Originally posted by rlaubert
What is it you want to do with the log. Are you looking at Transaction logs or SQL Server Activity logs?For Transaction Logs you can use DBCC Log(DBname, 3) to get a good idea what is going on.
But DBCC Log is pretty unreadable without the third party tools unless you work on the SQL Server team at Microsoft!Tara Kizer |
|
|
|
|
|
|
Log analyzer tool