Help and Support

Internet Information Server Performance Logging to Disk vs. ODBC

Article ID:142557
Last Review:June 23, 2005
Revision:3.1
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 (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.

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

Back to the top

Keywords: 
kbinterop KB142557

Article Translations

 

Related Support Centers

Other Support Options

  • Contact Microsoft
    Phone Numbers, Support Options and Pricing, Online Help, and more.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.