Why is the text log file format TMG 2010/ISA 2006(w3c)better than MSDE/SQLExpress/MS SQL format?
The question is often asked, why is it necessary to use the text log file format w3c, instead of the MSDE format which is the default for Forefront TMG 2010/ISA 2006.
The second reason is the volume that log files take up on the server's disk. MSDE/SQL Express format log files take up to 6-8 times more space than w3c format text log files. In addition, with w3c, unused fields can be switched off, which reduces log file size even more. For example, if the weekly volume of log files in MSDE format is 1000MB, then with w3c format this reduces to about 150MB.
The third reason is TMG/ISA server productivity. It is clear that text log files take much less processing time and reduce the workload of the disk subsystem.
The only disadvantage of using w3c log files is that reports embedded in Forefront TMG 2010/ISA 2006 do not work. However, this is not a serious disadvantage if ProxyInspector is used.