????? ??????? SQL Server ??? ????? ????? ???

?????? ????????? ?????? ?????????
???? ???????: 296085 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

??????

???? ????/????? ??????? ?????? ??? ?? ??????? ?????? ???????? ?? ??????? ????? ???. ????? ????? ??? ??????? ???? ????? ??? ???? ??? ?? ???? ?????? ?? ??? ??????? ?? ??? ?????. ????? ???? ??????? ???????? ??? ??? ??????? ???? ???? ??????? ????????? ??????? ???????? ???.

???? ??? ??????? ????? ???? ???? ??????? ????? IIS ?? ????? "???? ????? ????? ???? ??? ????????" (W3C) ??? Microsoft SQL Server ?????? ???????? ????? ??? IIS. ???? ????? ??? ????? ???????? ???????? ?????? ???????? ??? ?????.

??????? ????

????? ??? ????? ???? ????? ??? ?? ???? ?? RFC 2616 ? "???? ??????? ??? ????????--HTTP/1.1" (http://www.rfc-editor.org/rfc/rfc2616.txt).

?? ????? W3C Extended ????? ???? ?????? ?????? ??? ?? ?? ??????: ???????? ?????? ??? ??? ?? ?????? ???? [c-ip ?? ????? IP ?????? [????? cs] ?? ??????? HTTP ??? ?? ?????; [cs-uri-???] ?? ??????? ???? ?? ???; [cs-uri-?????????] ?? ????? ????????? ???? ?? ??????? ???? ?? ??? ?????; [sc ????] ?? ??? ?????? ???? ?? ?????? ?? ??? ??????; [sc ????] ?? ??? ????? ?????? ???? ?? ??? ??????? ??? ????????; [??? ???] ????? ??????? ????? ???????? ?????? ????? ???????? ?????; [cs(Cookie)] ?? ??? ????? ???????? ?? ???????? ???????? ?? ?????; ? [cs(Referer)] ?? ???? ???? ????????? ?????? ??????? ???? ??? ??????? ?? ??? ????????. ????? W3C Extended ????? ???? ??? ?? ?????? ???????? ???? ???? ???????? ???? ???? ???? ????? ?? ??????? IIS ? ?? ???? Microsoft ?????? ??? ?????:
http://msdn.microsoft.com/en-us/library/ms525152.aspx
??? ????? ??????? ??? ???:

?? ??? ??????????? ??? ??????
??????????c-ip????? cscs uri ?????cs uri ????????????? sc????? ?????? sc??? ?????cs(User-Agent)cs(Cookie)cs(Referrer)


?????? ?? ??? ????? ????? ??? ???? ?????? ?? ????? ???? ??? ??? ????? ??????? ???? ??? ? ?? ?????? ?????? W3C Extended ??????? ? ????? ??????? ????? ?????. ??? ???? ????? ??? ?????? ?? ???? ?? Microsoft SQL Server, ??? ??????? ????? ??????? ODBC. ??? ???? ??? ??????? ODBC ????? ?????? ??? ????? ???????. ??????? IIS ??? ??????? ??? ????? ????? ODBC ????? ????? ???????? Logtemp.sql ?????? ?????? ?? ???? ???????.

????? ??????? ????? ??????? ????? ?????? ???? ???? ??? ???? ???????? ?? ????? ???????, ????? ?? ??????? ???????? ????? ?????? ?? "???? ???????" ?????? ??????:
CREATE TABLE [dbo].[tablename] (
	[date] [datetime] NULL,
	[time] [datetime] NULL ,
	[c-ip] [varchar] (50) NULL ,
	[cs-method] [varchar] (50) NULL ,
	[cs-uri-stem] [varchar] (255) NULL ,
	[cs-uri-query] [varchar] (2048) NULL ,
	[sc-status] [int] NULL ,
	[sc-bytes] [int] NULL ,
	[time-taken] [int] NULL ,
	[cs(User-Agent)] [varchar] (255) NULL ,
	[cs(Cookie)] [varchar] (2048) NULL ,
	[cs(Referer)] [varchar] (2048) NULL 
	)
				

???? ?? ??? ??? ?????? ?????? ????? ?? ?? ???? ?????? ?? ??? ?????? ????? ??? ????.

????? ????? ?????? ????? ??????? ???????? ???????? "????? ?????????" ????? ?? ??? *.log ??? ????? ?????? ?????.

???? ?? ?????, ???????? ??????? ???? ???? ??????? ??????? ???? ??? ????? ??????? ????? ???:
BULK INSERT [dbo].[tablename] FROM 'c:\weblog.log'
WITH (
    FIELDTERMINATOR = ' ',
    ROWTERMINATOR = '\n'
)
				

???? ??? ????? ????? ????? ????? ????? ?????? ???? ???? ?? "#". ????? ??? ????? ??? ?????? ??????? ?????? ???????? ??? ??? ?????? ???? ??? ????? ?????? ?? ??? ??? ?? ??? ??????? ???? ??? ??? ????? ????? ??????. ???? ???? ????? ??????? ?????? ???????? ?????????? ???????? ?????? ??? ????? ??? ?????? ????? ????? ????? ????? ????? ??? ???? SQL:
296093FILE: ??????? PrepWebLog ?????? ????? IIS ?????? ??? ????? ???? SQL
??? ?????? ?????????, ???? ??????? "???? ???????" ????? ??????????? ?????? ???????? ". ??? ???? ??????:
Select [cs-uri-stem], [time-taken] from tablename where [time-taken] >= 20000 and time between '1899-12-30 16:30:00.000' and '1899-12-30 17:30:00.000' 
				
???? ??? ????????? ????? ???? ??????? ???? ??? ???? ?? 20 ????? ??????? ? ???? ??? ?????? ??? 4: 30 ? 5: 30 ?, ?? ??? ????? (??????? ?????) ?? ??? ??.

???? ?? ?????? ???? ??? ?????????? ???? ??? ????? ????? ?? ??? ????? ?????? ???? ??? ??? ?? ????? ????????? ?????? ??????? ?? ??????? ?????? ??? ???? ??? ??????? ?????? ??? ?????? ???????.

??????? ????? ???:
Select distinct [cs-uri-stem], [time-taken] from tablename where [time-taken] > (select avg([time-taken]) from tablename)order by [time-taken] desc
				
??? ????????? ?? ??????? [???- ???] ??? ????? ?? ??? ??? ?? ?????? [cs-uri-?????] ? ?? [???- ???] ? ???? ??? ?????? ?????? ?????? [??? ???]. ????? ????? "????? ???" ?? ??? ????? ????????? ??? ??????.

?????

??????: ????? ????? ????? ?? ???? ?? SQL Server 7.0 ???? ???? ?? SQL Server 2000. ?????? ??? ??????? ??????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
272292??? BUG: 7399 ????? ???? ??????? ????? ?? ???? ?? ???? ????????? ??? NUMERIC ?? ??????? ????
?????? ??? ???? ?? ????????? ??? LocalTimeRollover ????? IIS ? ??????? LogFileLocaltimeRollover:
http://msdn.microsoft.com/en-us/library/microsoft.web.administration.sitelogfile.localtimerollover.aspx

???????

???? ???????: 296085 - ????? ??? ??????: 30/????/1427 - ??????: 3.3
????? ???
  • ???? ??????? ?????? 3.0
  • Microsoft Internet Information Server 4.0
  • Microsoft Internet Information Services 5.0
????? ??????: 
kbmt kbhowto KB296085 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????296085

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com