Internet Information Server Performance Logging to Disk vs. ODBC

Last reviewed: April 22, 1997
Article ID: Q142557
The information in this article applies to:
  • Microsoft Internet Information Server version 1.0

SUMMARY

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

MORE INFORMATION

If disk logging is used, data is cached in 64k chunks. Once 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 logging is used, the log is always up to date because SQL 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.


Additional query words: prodiis
Keywords : iissetup kbinterop
Version : 1.0
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 22, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.