KB142557 - Internet Information Server Performance Logging to Disk vs. ODBC

Article ID: 142557

Article Last Modified on 6/23/2005

Microsoft Internet Information Server 1.0
Microsoft Internet Information Server 2.0
Microsoft Internet Information Server 3.0
Microsoft Internet Information Server 4.0

This article was previously published under Q142557

We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site:

http://www.microsoft.com/technet/security/prodtech/IIS.mspx

SUMMARY

The impact of logging Internet Information Server (IIS) activity to disk is minimal compared to logging it to a SQL Server database. The performance impact of logging to SQL Server is greater and depends on the SQL Server implementation and the hardware you use. See your SQL Server documentation for more information on increasing performance.

MORE INFORMATION

If disk logging is used, data is cached in 64K chunks. When the server has 64K of log data cached, it writes the data to disk.

NOTE: Stopping the WWW, FTP, or Gopher service forces the cached data to be written to the log file. If SQL Server logging is used, the log is always up to date because SQL Server entries are written immediately.

You may experience problems implementing live reports when using these files as the data source for two reasons:

The current log file is held open until it reaches the maximum size or time interval specified in the Internet Server Manager. The log file closes when the next log entry is written after midnight of the day the log file time limit expires.
The log file is updated in 64K chunks. On servers that do not have a high usage rate, the statistics will not be up-to-date because of the delayed write.

Keywords: kbinterop KB142557