Click here to monitor SSC
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
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 78
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
SSC-Enthusiastic
SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)

Group: General Forum Members
Points: 163 Visits: 1122
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
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 Visits: 78
thank you!!!
You are right, when I did your scritp, the table compressed.
Jeffrey Irish
Jeffrey Irish
SSC-Enthusiastic
SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)SSC-Enthusiastic (163 reputation)

Group: General Forum Members
Points: 163 Visits: 1122
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