Tuesday, August 3, 2010

iis mssql table filed description

Table 6.3 Meaning of Table Columns

ColumnMeaning
ClientHostWeb client IP address
usernameWeb client user name (usually blank)
LogTimeData and time of request
serviceInternet Information Server service requested by the Web client
machineName of machine hosting Internet Information Server
serveripIP address used to access Internet Information Server
processingtimeHow long the request took to process
bytesrecvdHow many bytes the Web client sent
bytessentHow many bytes the Internet Information Server sent back to the Web client
servicestatusThe Internet Information Server status sent back to the Web client
win32statusWindows NT Server operating system status code
operationOperation request by the Web client
targetWeb resource requested by the Web client
parametersParameters sent by the Web client

Caution
Performance problems are possible when logging Internet Information Server activity to a database on the same platform. Plan to log activity to a database on another platform.