SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


download IIS log from .log file


download IIS log from .log file

Author
Message
ISuleymanovH
ISuleymanovH
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 102
Hello.

I'm sorry for my English.
I have a task, download into my table IIS log and compress this table

Now I did such
Download from MS site programm LogParser, and did a bat file
"C:\Program Files (x86)\Log Parser 2.2\LogParser.exe" "SELECT * INTO LogIIS FROM C:\test\u_*.log " -i:IISW3C -o:SQL -database:AdventureWorks2012
Work very well!!)

The first problem was, if I do table with one column varchar(max) and then ALTER TABLE LogIIS REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = PAGE), compress don't work, but I couldn'y understand how to parse with internal function of sql server?

Question, can i do this task without other programm? I mean without LogParser?

Table
LogIIS
LogFileName varchar
logRow int
dateLog datetime
timeLog datetime
c_ip varchar
cs_username varchar
s_sitename varchar
s_compname varchar
s_ip2 varchar
s_port int
cs_method char
cs_uri_ste varchar
cs_uri_quer varchar
sc_status int
sc_substatus int
cs_win_sta int
sc_bytes int
cs_bytes int
time_taken int
cs_version varchar
cs_host varchar
cs_us_agent varchar
cs_cokiee varchar
cs_reffer varchar
s_event varchar
s_proc_type varchar
s_user_time real
s_kern_time real
s_page_fault int
s_total_faul int
s_active_pro int
s_stoppe_pro int
Jeffrey Irish
Jeffrey Irish
Old Hand
Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)

Group: General Forum Members
Points: 306 Visits: 1144
Perhaps you don't have partitions?

It looks to me that you can complete page level compression for the whole table by doing this:
ALTER TABLE T1 REBUILD WITH (DATA_COMPRESSION = PAGE)



It's worth a try anyway.

Regards,

Irish w00t
ISuleymanovH
ISuleymanovH
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 Visits: 102
thank you!!!
You are right, when I did your scritp, the table compressed.
Jeffrey Irish
Jeffrey Irish
Old Hand
Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)Old Hand (306 reputation)

Group: General Forum Members
Points: 306 Visits: 1144
I'm just glad I could help!

Regards,

Irish w00t
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search