[dba-SQLServer]

Thanks Eric.   Good point.  I'm storing it twice in case they purge the IIS 
logs.  I have no control over  what happens to that server.


>From: "Eric Barro" <ebarro at afsweb.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: RE: [dba-SQLServer]
>Date: Tue, 14 Oct 2003 12:30:39 -0700
>
>I still recommend running a query on the table. I have the same setup and I 
>have an ASP page that uses a SQL view to pull only those records that show 
>an error 500 for the current day. If you index on fields you will be 
>querying on (especially the ones that appear after the WHERE clause in SQL) 
>you should be fine performance wise.
>
>Why store the data twice when you can get subsets of it using queries?
>
>---
>Eric Barro
>Senior Systems Analyst
>Advanced Field Services
>(208) 772-7060
>http://www.afsweb.com
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Billy
>Pang
>Sent: Tuesday, October 14, 2003 11:49 AM
>To: dba-sqlserver at databaseadvisors.com
>Subject: RE: [dba-SQLServer]
>
>
>IIS records everything in that table.  I imgaine on a heavy traffic day
>there will be millions records insert into it that day alone.  I only care
>about maybe a hand full of records in that table.
>
>Billy
>
> >From: "Eric Barro" <ebarro at afsweb.com>
> >Reply-To: dba-sqlserver at databaseadvisors.com
> >To: <dba-sqlserver at databaseadvisors.com>
> >Subject: RE: [dba-SQLServer]
> >Date: Tue, 14 Oct 2003 10:53:16 -0700
> >
> >Billy,
> >
> >What's the purpose of exporting those records? If it's for statistical
> >purposes why not just run queries on the table?
> >
> >---
> >Eric Barro
> >Senior Systems Analyst
> >Advanced Field Services
> >(208) 772-7060
> >http://www.afsweb.com
> >
> >-----Original Message-----
> >From: dba-sqlserver-bounces at databaseadvisors.com
> >[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Billy
> >Pang
> >Sent: Tuesday, October 14, 2003 10:47 AM
> >To: dba-SQLServer at databaseadvisors.com
> >Subject: [dba-SQLServer]
> >
> >
> >Hello:
> >
> >Our IIS Server is logging website hits to SQL Server.  We are trying to
> >figure out best way to export certain records from this table into 
>another
> >table every 5 minutes.  So far, we came up with two options:
> >
> >1) in a separate table, store the ID of the last record in the IIS Log
> >table
> >that was exported.  Every 5 minutes, export the records that are greater
> >than the last exported ID.
> >
> >2) pick one of the columns in the log table to be the "Exported" flag
> >column.  After exporting a record from the log table, update that record 
>as
> >exported.
> >
> >We are leaning towards #2 but am unsure about any locking issues.  AKAIK,
> >IIS only inserts records into that table, never update.
> >
> >Any ideas or thoughts?
> >
> >Thanks in advance,
> >Billy
> >
> >_________________________________________________________________
> >The new MSN 8: advanced junk mail protection and 2 months FREE*
> >http://join.msn.com/?page=features/junkmail
> >
> >_______________________________________________
> >dba-SQLServer mailing list
> >dba-SQLServer at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> >http://www.databaseadvisors.com
> >
> >---
> >Incoming mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
> >
> >---
> >Outgoing mail is certified Virus Free.
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
> >
> >_______________________________________________
> >dba-SQLServer mailing list
> >dba-SQLServer at databaseadvisors.com
> >http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> >http://www.databaseadvisors.com
> >
>
>_________________________________________________________________
>Tired of spam? Get advanced junk mail protection with MSN 8.
>http://join.msn.com/?page=features/junkmail
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
>
>---
>Outgoing mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.525 / Virus Database: 322 - Release Date: 10/9/2003
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus